GMM to Google Sheets
One way to integrate GMM to Google Sheets is to use the Google Sheets premium action in Workflows. Premium actions cost $0.01 per execution (i.e. if it runs every time a new contact is created, after 100 contacts you will be charged $1.00)
This can be set up in the Automations tab in a Workflow
Step 1 - Create a New Workflow (+ Start from Scratch)
Step 2 - Set your Trigger(s)
Title your workflow and set your trigger. The trigger will be whatever you want to cause someone to be added to your google sheet i.e. every time a new contact is created, when a certain form is submitted, when the lead tag is added, etc. you can set more than one trigger if needed!
Click Save after each change you make!
Once the trigger is set, add the Google Sheet action as the first step
Step 3 - Add the Google Sheets action
Click the + icon below the triggers to add your first action.
Step 4 - Fill out the fields for the Google Sheets action
If you want a person to be added to your sheet as a new row - click Create Spreadsheet row under Action name.
Choose your Google Account
Note: your google account must be connected in the integrations tab for it to show
To connect it, go to Settings → Integrations → Sign in with Google
Select the Drive and Spreadsheet and Worksheets in the given fields
Step 5 - Map your Google Sheets columns to the Google Sheets action
Under the Worksheet field will be Starting and Ending Column, this will be based on your Google Sheet (the name of your first column and the name of the last one)
For example, the starting column on the sheet below is Name (A), and the last one is Date (D)
Set the starting and ending columns then the columns should appear for you to add in a custom field for each one
Most common custom fields name and their value:
Full Name: {{contact.name}}
Email: {{contact.email}}
Phone: {{contact.phone}}
Date: {{right_now.middle_endian_date}}
Once all are set, click Save Action
Step 6 - Click Publish, Save and Test!
Once your workflow is set to Published and Save
It is now ready for a test!
To test it, simply use a test contact (such as yourself) and recreate the trigger whether it be adding a tag, filling out a form, etc.
Once you perform the test, check your Google Sheet to make sure the contact was added and the fields line up:
