Docs

Google Spreadsheets

Updated on

When you connect Google Spreadsheets to FunnelKit Automations, you get three actions to take:

  • Insert Row
  • Update Row
  • Delete Row

Let’s look at how to set up these actions.

Create an Automation

Click on Add New in Automations.

Campaigns menu open on Automations Next Gen, with an arrow on the Add New Automation button

Hit Start from Scratch and name your automation.

Add Automation modal with an empty automation name field and arrows on the Create button

Click on Create.

From the events listed on the right side of the screen, select Order Created.

Order created WooCommerce google sheets

Configure this trigger by clicking on it.

Order Created event settings for sending data to Google Sheets

Next, click on the + icon to add an action to this event.

Add action FunnelKit automations

From the drop-down menu select the option of Insert Row under Send Data.

From the drop-down menu select the option of Insert Row under Send Data

In another window, open the Google spreadsheet you want to connect to the automation, and copy the Google Sheet ID (as highlighted in the image below).

In another window, open the Google spreadsheet you want to connect to the automation, and copy the Google

Important: The Google Sheet ID is not the complete URL, but only a part of it, so be careful when you are copying it.

Paste the link in the respective field on the Automation page and click on Get Sheets.

Paste the link in the respective field on the Automation page and click on Get Sheets

Now you may add the required columns to the spreadsheet.

Now you may add the required columns to the spreadsheet

Search and add appropriate Merge Tags to the respective columns in the automation.

Search and add appropriate Merge Tags to the respective columns in the automation

Click on the Save button to lock all the changes.

Make the automation live by turning the toggle to Active.

Test the Automation

Place a test order to check the task execution.

Place a test order to check the task execution

Now go to Contacts in Automation.

Here you’d be able to see a new active contact for the order you just placed.

Active contacts automation

You will see the connected spreadsheet once the task is completed.

The relevant data from the order placed will be updated in the sheet.

The relevant data from the order placed will be updated in the sheet

And that’s how you set up actions of Google Spreadsheets in FunnelKit Automations.