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