Add Exported WordPress Data to Google Sheets using Zapier
Zapier can be used to send details of the export data towards Google Sheets. Connect Zapier to WP All Export and create the required trigger and action. The trigger would execute whenever a new export is found. The action would be sending the export information to Google Sheets.
Trigger: New Export File in WP All Export Pro
First, connect to Zapier and set up the required trigger: https://www.wpallimport.com/documentation/external-app-integration/.
Action: Create Spreadsheet Row in Google Sheets
Choose App & Event
Zapier will prompt to create an action once the trigger is done.
Select Google Sheets as the app and Create Spreadsheet Row as the event, then click Continue.
Select the Google Sheets account to use. If there's no account added, select + Connect a new account from the dropdown list and follow the steps.
Once an account has been selected, click Continue.
Set up action
This section allows configuring in which spreadsheet and worksheet the information will be added.
The following can be configured:
- Drive: The Google Drive where the spreadsheet resides. The personal Google Drive is used if nothing is selected.
- Spreadsheet: Select which spreadsheet should be used by Zapier.
- Worksheet: Select which worksheet within the spreadsheet should be the data added to.
Once those fields have been selected, Zapier will load headers from the worksheet and allow to select which data is added into those columns. If there are no headers in the worksheet, Zapier will ask to set up the spreadsheet.
The following data can be added to the spreadsheet:
- Export Name
- Export File URL
- Export Last Run Date
- Records Exported
- File Name
- Export Created Date
- Status Code
- Website URL
- File Type
- Post Types Exported
- Status Message
- Export ID
- Export Trigger Type
Only details from the export can be added to the spreadsheet. Filling the Google Sheet rows with the data from the exported file is not possible with this integration. If that's the desired result, the Google Drive integration should be used instead.
Once the action has been configured, Zapier will attempt to test it. Select Skip Test to avoid this step.
Otherwise, click Test & Continue to check everything is working.
Once the test is successful, the zap can be enabled by clicking on Turn on Zap.