Programmatic SEO: How I got on top of Google with WordPress, Elementor, and a bit of Python

import openpyxl

# Define the paths of your Programmatic SEO project:
template_file_path = 'C:\\Users\\Bogdan\\Desktop\\Programmatic SEO Project\\elementor_code.txt'  # Specify the path to the file containing the Elementor code
input_file_path = 'C:\\Users\\Bogdan\\Desktop\\Programmatic SEO Project\\variables_and_content.xlsx'  # Specify the path to the Excel file (where you defined variables and content)
output_directory = 'C:\\Users\\Bogdan\\Desktop\\Programmatic SEO Project\\Output\\'  # Specify the path to the folder where the new templates will be created

# Enter the names of your variables ( these must be identical to the column headings in your Excel document)
# The first variable will be used as a modifier in the template names created
variable_names = ['TOWN_NAME', 'WIKI_URL', 'PAGE_URL_SLUG', 'SLIDER_DESCRIPTION', 
                  'LINK_BUILDING_SERVICES', 'LOCAL_SEO_SERVICES', 'SEO_ON_PAGE_SERVICES', 
                  'SEO_CONTENT_SERVICES']  # Enter your variables between single quotes and use a comma to separate them


# DO NOT edit the code below
def replace_variables(template, **kwargs):
    for key, value in kwargs.items():
        template = template.replace(f'[{key.upper()}]', str(value))
    return template

with open(template_file_path, 'r', encoding='utf-8') as f:
    elementor_template = f.read()

wb = openpyxl.load_workbook(input_file_path)
ws = wb.active

file_count = 0

output_variable_name = variable_names[0]

for i, row in enumerate(ws.iter_rows(min_row=2, values_only=True), start=1):
    variables = dict(zip(variable_names, row[:len(variable_names)]))
    output_filename = f'{output_directory}elementor_code_{variables[output_variable_name]}.txt'
    output_content = replace_variables(elementor_template, **variables)
    with open(output_filename, 'w', encoding='utf-8') as f:
        f.write(output_content)
    file_count += 1
    print(f"{i}. File '{output_filename}' successfully generated.")

print("")
print("Finished.")
print(f"Total files generated: {file_count}")
input("Press Enter to exit...")