Activating Google Sheet Sync in LPagery
Google Sheet Sync in LPagery allows you to automatically create, update, and delete pages based on the data in your Google Sheet, without needing to log into WordPress manually. This feature enables:
Automated Page Creation: Add new rows to your Google Sheet, and LPagery will automatically generate pages for them.
Seamless Updates: Modify existing data in your Google Sheet, and the corresponding WordPress pages will be updated after the sync.
Page Deletions: Remove rows in your Google Sheet, and LPagery will delete the associated pages in WordPress, provided the sync is configured to do so.
You can enable this sync either during the initial page creation process or later, but it can only be activated for Google Sheet inputs, not for CSV/XLSX or radius inputs.
This feature is available for the LPagery Extended plan and above.
Click here to purchase LPagery Pro ->
How to Activate Google Sheet Sync
During Initial Page Creation:
When setting up a new page set with Google Sheets as your data input, toggle the sync option before you create the pages.
First select Google Sheet as input type.
Then enable the toggle for the Google Sheet Sync
Configure Sync Settings:
Sync Page Creations: New pages will be created automatically when you add new rows to the Google Sheet.
Sync Page Updates: Pages will be updated when changes are made to the corresponding rows in the Google Sheet.
Sync Page Deletions: Pages will be deleted in WordPress if their corresponding rows are removed from the Google Sheet.
Create the pages. LPagery will now check for changes in your Google Sheet in the set schedule.
After Page Set Creation:
If pages have already been created using a Google Sheet, you can later enable sync through the LPagery settings.
Go to "Manage Pages":
Click on the menu icon of the page set you want to enable the Google Sheet Sync for:
Click on "Google Sheet Sync Settings
Enable the Google Sheet Sync and adjust the settings
Syncing Process
After enabling sync, LPagery will automatically update pages based on your Google Sheet changes according to the configured schedule. You can manage sync settings, view logs, and monitor the next sync from the LPagery dashboard.
For more details on setting up Google Sheet Sync and advanced configurations, check out our Google Sheet Sync guide.