Spreadsheets · 10 ready-made steps

Google Sheets Integration

Sign in with Google and use ten ready-made steps in MapleConnect automations to add, update and read rows in your spreadsheets.

GOOGLE SHEETS → MAPLECONNECTGSGoogle SheetsMapleConnectAutomations

MapleConnect connects to Google Sheets through the automation builder. Add a Google Sheets step to an automation and it can add a row for every new lead, update a row when the lead changes, or read rows to use in the next step.

You connect by signing in with the Google account that owns or can edit the spreadsheet.

What you can do

Once Google Sheets is connected

Add a row for each record

Append a row, or append or update: update the matching row if one exists, otherwise add a new one.

Read and update rows

Read rows, optionally only those where a column matches a value, and update a row.

Manage sheets

Create a spreadsheet or a sheet, clear a sheet, and delete rows, columns, sheets or spreadsheets.

Connect — Sign in

How to connect Google Sheets to MapleConnect

  1. 01

    Add a Google Sheets credential

    In MapleConnect, go to Automations, then Credentials, and add a Google Sheets credential.

  2. 02

    Sign in with Google

    Click Sign in with Google and approve access with the account that can edit your spreadsheets.

  3. 03

    Add a Google Sheets step to an automation

    Open an automation, add a Google Sheets step such as Append Row, pick your Google Sheets credential and map fields from the lead, contact or booking that started the automation.

  4. 04

    Publish the automation

    Publish the automation. From then on the step runs every time the automation does, for example when a new lead arrives, a lead changes status, a booking is made, or on a schedule you set.

FAQ

Google Sheets integration — FAQs

Everything you need to know before going live. Can't find what you're looking for? Our team is one message away.

Talk to us

Still have a question?

Questions before you start? Call or message our team.

Call a human(480) 650-9911

Cancel anytime · 14-day free trial

Add a Google Sheets credential under Automations, then Credentials, and sign in with Google. Then add Google Sheets steps to an automation.
Not with the ready-made steps: they write to and read from a sheet when an automation runs, and none of them watches a sheet for new rows. To send rows in as leads, the sheet has to post them to a lead source’s webhook URL, for example from a Google Apps Script.
No. Nothing moves between the two on its own. Data moves when an automation you built runs a Google Sheets step, so you decide which records are created or changed, and when.
Explore the platform

Related features & pages

Other integrations