Connecting Google Sheets to Your Store
Adding Multiple Google Sheets
Go to WooCommerce > Google Sheets.
Here you can:
- View a complete list of Google Sheets created
- Perform bulk actions to edit or delete a Google Sheet
- Filter Google Sheets by dates
- Search for a specific Google Sheet using the search bar
Click on the “Add New Post” button to create a new Google Sheet.
Fill in the following details:
Add Title: Enter a title for your Google Sheet
Google Sheets Connector:
Click on “Add New Sheet”
Google Sheet ID: Enter the Google Sheet ID
Google Sheet Name and Range: Define the range of the sheet, which must be selected from A to AM
Map Form Fields:
Webhook Key: Provide a webhook key
Form Field: Select the desired field from the dropdown menu
Add multiple rows or take action to delete any form field as needed.
Click on “Sync Entries” to synchronize your data with the Google Sheet. Please remember to save your changes before initiating the sync
Configuring Authentication Settings
Authentication settings ensure secure access to your Google Sheets.
Go to WooCommerce > Google Sheets > Google Sheet Connector Settings.
Authentication Settings:
Upload Credentials.json File: Upload the credentials.json file associated with your Google account
App Name: Enter the name of your application
