Deleting First 7 Rows

Phishdawg 

1. It added columns headers (Column1, Column2, Column3, etc.), as row one with my original workbook column headers on row 2. How do I prevent the default numbered columns from being created?

Assuming I understand (not sure)... You can't prevent this from happening as a Table must have headers and if you don't provide those headers in a way or another, Power Query - as default - name them Column1, Column2...

As I understand your scenario, either before or after removing the top 7 rows you can rename Column1, Column2... as you want. Just double-click a column name and enter the desired name

2. Can this process be automated...

Looks like you're in good hands with SergeiBaklan and I don't have access to Power Automate so won't be able to help with this

Phishdawg 

As variant,

you may create ExcelScript under Automate like

function main(workbook: ExcelScript.Workbook) {

	const sheet = workbook
		.getWorksheets()[0]

	sheet
		.getRange("1:7")
		.delete(ExcelScript.DeleteShiftDirection.up)

	const newTable = workbook
		.addTable( sheet.getRange("A1:M100"), false )

	// clean empty rows
	const values = newTable
		.getRangeBetweenHeaderAndTotal()
		.getValues()
	const rows: number[] = []
	let rowInd: number = 0;
	
	values
		.forEach( v => {
				if ( v.join("") == "") {
					rows.push(rowInd)
				} rowInd++
		} )

	for (let n = rows.length - 1; n > -1; n--) {
		newTable.deleteRowsAt(rows[n]);
	}

}

which removes first 7 rows, on predefined with some gap creates the table and removes empty rows from it.

Next, in Power Automate create the flow, just couple of steps could be enough - it is triggered when any new file is added to the SharePoint folder and run above script on that file

Above is only mock-up, details depend on your environment and logic of the process.