Google Sheets + Square

Update Google Sheets rows with new Square payments

With this workflow, every time a new payment is recorded in the Square app, a corresponding row in a predefined Google Sheets spreadsheet is updated. This seamless connection between Square payments and Google Sheets not only keeps your financial records consistently updated but also helps in efficient tracking of every transaction. It's an automatic, useful tool to streamline your bookkeeping process, saving time and reducing human error.

With this workflow, every time a new payment is recorded in the Square app, a corresponding row in a predefined Google Sheets spreadsheet is updated. This seamless connection between Square payments and Google Sheets not only keeps your financial records consistently updated but also helps in efficient tracking of every transaction. It's an automatic, useful tool to streamline your bookkeeping process, saving time and reducing human error.

  1. When this happens...
    SquareSquare
    New Payment

    Triggers when a new payment is created.

    TriggerScheduled
  2. automatically do this!
    Google SheetsGoogle Sheets
    Update Spreadsheet Row(s)

    Update one or more new rows in a specific spreadsheet (with line item support).

    ActionWrite
Start free with email
Start free with email
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

What does this mean?
  • Square triggers, actions, and search

    New Appointment

    Triggers when a new appointment is created.

    Trigger
    Scheduled
    Try It
  • Square triggers, actions, and search

    New Customer

    Triggers when a new customer is created.

    Trigger
    Scheduled
    Try It
    • LocationRequired

    • Order Status

    Trigger
    Scheduled
    Try It
    • Customer IDRequired

    • GroupRequired

    Action
    Write
    • Item Type

    Trigger
    Scheduled
    Try It
    • LocationRequired

    Trigger
    Scheduled
    Try It
    • Location

    Trigger
    Scheduled
    Try It
    • LocationRequired

    • Team Member IDRequired

    • Customer IDRequired

    • Date and Time of AppointmentRequired

    • Appointment Service IDRequired

    • Note

    Action
    Write
google-sheets logo
google-sheets logo

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Learn moreHelp

Related categories

  • Google
  • Spreadsheets

Similar apps

Zapier Tables integrationsZapier Tables integrations

Zapier Tables

Databases, Spreadsheets, Zapier
Zoho Creator integrationsZoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrationsSmartsheet integrations

Smartsheet

Spreadsheets
square logo
square logo

About Square

Square creates tools that help sellers of all sizes start, run and grow their businesses. Square’s point-of-sale service offers tools for every part of running a business, from accepting credit cards and tracking inventory to real-time analytics and invoicing.
Learn moreHelp

Related categories

  • eCommerce
  • Payment Processing

Similar apps

PayPal integrationsPayPal integrations

PayPal

Payment Processing
Shopify integrationsShopify integrations

Shopify

eCommerce
Epos Now integrationsEpos Now integrations

Epos Now

Payment Processing