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.
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.
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.
How to connect Google Sheets to MapleConnect
- 01
Add a Google Sheets credential
In MapleConnect, go to Automations, then Credentials, and add a Google Sheets credential.
- 02
Sign in with Google
Click Sign in with Google and approve access with the account that can edit your spreadsheets.
- 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.
- 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.