Using Google Sheets as your data source in LPagery allows you to easily create pages directly from your Google Sheet without needing to download a source file. Below is a step-by-step guide to importing data from Google Sheets and generating pages.
This is a LPagery Pro Feature!
The features in this tutorial are not included in the free version of LPagery.
Buy LPagery Pro now to access the Google Sheet input
Step 1: Create a Google Sheet
Start by creating a new Google Sheet. This sheet will serve as your source file and should contain all the necessary data for page generation.
Go to Google Sheets and create a new spreadsheet.
Ensure that the first row contains column headers for placeholders (e.g.,
service,city, etc.).
Step 2: Enter Source Data
Input your source data just like you would for a normal LPagery source file. Each row will represent the data for one generated page.
For example:
Column 1:
{service}Column 2:
{city}
Each subsequent row will contain different services and city names. This data will be dynamically inserted into your template pages.
You can find more information on this here: Create a source file ->
Step 3: Share the Google Sheet
To allow LPagery to access your Google Sheet, you must share the sheet correctly:
Click the “Share” button at the top-right of the Google Sheet.
In the sharing settings, change the link permissions to “Anyone with the link can view.”
Copy the sharing URL, which you will need in the next step.
This step is necessary, otherwise the Google Sheet will not be found by LPagery
Step 4: Select "Google Sheet" as Input
Inside the LPagery dashboard, follow these steps:
Choose the Google Sheet option as the input type (as shown in the image).
Paste the Google Sheet URL that you copied in the previous step.
If the Sheet is valid, the linking icon will appear green
Step 5: Optional - Enable Google Sheet Sync
If you want LPagery to automatically sync with your Google Sheet, you can enable the Google Sheet Sync feature. This will allow LPagery to automatically create, update, and delete pages based on changes made to your Google Sheet.
For more information on setting up the Google Sheet Sync, read the detailed article here.
Step 6: Create Pages
Once the Google Sheet is connected, you can proceed to generate pages just like you would with any other input method. LPagery will dynamically pull the data from your Google Sheet and use it to create pages based on the placeholders you’ve set in your template page.