How to Connect Square to Google Sheets Through Zapier

Quick summary

This tutorial shows you how to connect Square to Google Sheets using a Zapier automation, enabling Square payment and sales data to flow automatically into a spreadsheet without manual data entry. By setting up a Zap with Square as the Trigger app and Google Sheets as the Action app, you can keep your records updated in real time.

Steps

1. Navigate to the left-side panel in Zapier, then click Create.
2. Choose Zaps from the list of options.
3. Tap the Trigger tab to start the integration process.
4. Search for Square and choose it from the suggested results as your Trigger app.
5. Specify your preferred Trigger Event from the dropdown.
6. Tap Sign In and log into your active Square account.
7. Click Continue to proceed.
8. Fill in all the required information to set up the Trigger.
9. Tap Continue to run your input and test the Trigger.
10. Choose the record you wish to use, then tap Continue With Selected Record.
11. Search for Google Sheets and select it as the Action app.
12. Click the drop-down menu and pick the specific Action Event you wish to execute.
13. Click Sign In and log into your Google account.
14. Click Allow to accept the terms and grant the necessary permissions.
15. Fill out the input fields one by one with the required integration information.
16. Tap Continue to publish and enable the integration.
17. Your Square account is now connected to Google Sheets and the Zap is live.