Wix Automations: Sending Data to Google Sheets
Create an automation that sends data to Google Sheets, such as form submissions or invoice details. This allows you to collaborate with people using Google Sheets without giving them access to your site's dashboard.
Step 1 | Create a new automation and connect your Google account
To begin, create a new automation and add the action Update Google Sheets. Then connect your Google account so the automation can access the spreadsheet.
To create a new automation and connect your Google account:
Go to Automations in your site's dashboard.
Click + Create Automation at the top right.
Click + Start from Scratch.
Give your automation a title and choose a trigger.
Click the Add Step icon
and add an Action.
Select Update Google Sheets under Integrations on the left.
Click Connect Google Account.
Select the relevant Google account.
Click Allow.
Important:
When connecting your Google account, you are providing permissions for Wix to access your spreadsheet data. You can remove permissions at any time from your Google account.
If you remove Wix permissions, any automations that use Google Sheets will become disconnected and stop working. You can reset your Google permissions in an automation, but note that the trigger can't work retroactively or add any information that was "skipped" while the automation was disconnected.
Step 2 | Connect a spreadsheet to your automation
Next, connect the relevant spreadsheet to your automation. All spreadsheets in your connected Google account can be used in your automations. You can create new spreadsheets within Google Sheets and use these too.
Choose what you want to do:
Connect an existing spreadsheet to the automation
Click Select Spreadsheet.
Choose a spreadsheet from the available files.
(Spreadsheet with multiple tabs) Click the Choose sheet drop-down to select which tab the automation should send data to.
Tip: You can see how many tabs your spreadsheet has at the bottom of the Google Sheet.
Note: You can only sync spreadsheets that you created, not spreadsheets that were shared with you. If the spreadsheet you want to connect isn't owned by you, first make a copy of it in your Google account.
Create a new spreadsheet in Google Sheets and connect it
Go to Google Sheets in the connected Google account and create a new spreadsheet.
Add a spreadsheet title.
Add titles to the spreadsheet columns in order to organize the data that will be sent via the automation. For example, if you're sending data from invoices, add column titles for "Customer", "Invoice Total", etc.
Note: Be detailed with the column titles as in the next step you will match the data to a specific column on the spreadsheet.
Go back to the draft automation in your dashboard and click Select Spreadsheet.
Select the new spreadsheet you just created.
Tip: New spreadsheets appear at the top.
(Spreadsheet with multiple tabs) Click the Choose sheet drop-down to select which tab the automation should send data to.
Tip: You can see how many tabs your spreadsheet has at the bottom of the Google Sheet.
Step 3 | Match trigger data to the spreadsheet
Next, match the data from your chosen trigger to the correct columns in your spreadsheet. For example, if your trigger data includes customer and invoice total fields, you need to match that data to the "Customer" and "Invoice Total" spreadsheet columns.
To match your trigger data:
Click Match Data to Sheet.
Click the drop-downs under Data from trigger to match them to the Google sheet columns.
Note: If you need to make edits to column titles, do so within your Google spreadsheet and click Refresh Data at the bottom left to see these changes reflected.
Click Save.
Tip:
The data you send to a spreadsheet is different depending on the app. For example, Wix Forms sends form submission data like Name and Email fields, and Wix Stores sends data like recent store orders.
FAQs
Here are some common questions about Google Sheets automations:
I've edited the columns in my Google Sheet - how do I rematch the data?
If you edit the row with the columns, you need to reconfigure your automation. In the Action section of your automation, you can rematch the data to its appropriate Google Sheet column.
Go to Automations in your site's dashboard.
Hover over the relevant automation and click the More Actions icon
.
Click Edit.
Click the Action section to expand it.
Click Match Data to Sheet.
Select the data you want to match next to each Google sheet column.
Click Save.
What happens if I edit my Google Sheets permissions?
When setting up your automation, you need to provide permissions for Wix to access your spreadsheet data. If you remove or edit the permissions, the automation is disconnected and data is no longer sent to your spreadsheet.
Go to Automations in your site's dashboard.
Hover over the relevant automation and click the More Actions icon
.
Click Edit.
Click the Action section to expand it.
Click Disconnect Account.
Click Connect Google Account.
Make sure both checkboxes are selected to allow Wix to:
See and download all your Google Drive files.
See, edit, create, and delete all your Google Sheets spreadsheets.
Click Continue.
Click Save.
Note: You can remove 3rd party app access to your Google account at any time.
Why does my automation not show data from Google Sheets immediately after setup?
The integration between Wix Automations and Google Sheets may take a few moments to sync. If the data does not appear right away, wait a few minutes and refresh the page.
Tip: Go back to the automation and ensure that permissions for Google Sheets are correctly granted during the setup process.
Tip:
To quickly view the Google spreadsheet, click the More Actions icon
next to an existing automation in the Automations dashboard and click Open Google Sheet.
