Skip to main content

How can we help?

All Categories > What Is Example GLP Spreadsheet And How To Work With It

What Is Example GLP Spreadsheet And How To Work With It

Introduction to the Example GLP Spreadsheet

The GLP Spreadsheet is an essential component within our software, made to simplify the process of creating geo-targeted landing pages. It functions as a template filled with placeholders for variables, allowing users to input their specific information.

This guide will walk you through the steps of using the GLP Spreadsheet.

Using the Example GLP Spreadsheet

Step 1: Accessing the Spreadsheet

While creating a new WordPress, HubSpot or Drupal project within our software, you’ll have access to the Example GLP Spreadsheet. This spreadsheet contains pre-defined variables which will be used in the process of creation your landing pages.

Our software is going to take that initial seed page that you create with all of those variables. It’s gonna find those variables that you’ve included and then it’s gonna replace them with what we tell it to in the Google Sheet.

Step 2: Filling in Your Information

Your task is simple: populate the Example GLP Spreadsheet with your project-specific data.

Simply make a copy of example GLP spreadsheet and replace the placeholders with your actual data for as much pages as you need, ensuring accuracy and completeness.

Step 3: Variable-Value Mapping

Each variable in the Example GLP Spreadsheet corresponds to a specific element within your landing page.

Ensure that the values you input align with the intended purpose of each variable. This ensures that the generated landing pages accurately reflect your desired content and messaging.

  • Geo City – (city name variable) ex: Los Angeles
  • geourl – geourl
  • GeoSeoTitle – (page title variable) ex: Local SEO Geo City
  • GeoSeoMeta – (meta description variable) ex: Hire the best Geo City local SEO agency…”
  • geo-city – (file city name variable) ex: los-angeles
  • geo-exif-gps – (gps coordinate variable) ex: 38.59837,-128.45323
  • geo-exif-title – (exif title variable) target keyword
  • geo-exif-keywords – (exif keywords variable) keyword variations
  • geo-exif-description – (exif description variable) add meta description

Step 4: Saving Your Changes

Once you’ve filled in your information, save the changes made to your GLP Spreadsheet.

This ensures that your input is securely stored and readily accessible for the automated content personalization process.

Step 5: Add this Google Sheet to your project

Once you’ve saved the spreadsheet, you can now add it in Google Sheet Link input or insert Header and Data Rows from Spreadsheet. 

Step 6: Automated Content Personalization

Our software using the GLP Spreadsheet to automate the process of replacing placeholders with your specified information.

Sit back and relax as your landing pages are dynamically generated.