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.
![Add a new automation](https://funnelkit.com/wp-content/uploads/2022/10/click-add-new-automation.jpg)
Hit Start from Scratch and name your automation.
![Name your automation](https://funnelkit.com/wp-content/uploads/2022/11/name-automation-generalized-fka-1024x475.jpg)
Click on Create.
From the events listed on the right side of the screen, select Order Created.
![](https://funnelkit.com/wp-content/uploads/2022/11/order-created-woocommerce-google-sheets-1024x724.jpg)
Configure this trigger by clicking on it.
![](https://funnelkit.com/wp-content/uploads/2022/11/order-created-config-google-sheets.jpg)
Next, click on the + icon to add an action to this event.
![](https://funnelkit.com/wp-content/uploads/2022/06/add-action-autonami-nextgen-1024x522.jpg)
From the drop-down menu select the option of Insert Row under Send Data.
![](https://funnelkit.com/wp-content/uploads/2022/11/insert-row-action-1024x633.jpg)
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).
![](https://funnelkit.com/wp-content/uploads/2021/01/step-12.jpeg)
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.
![](https://funnelkit.com/wp-content/uploads/2022/04/5-copy-33-1024x576.jpg)
Now you may add the required columns to the spreadsheet.
![](https://funnelkit.com/wp-content/uploads/2022/04/6-copy-27-1024x576.jpg)
Search and add appropriate Merge Tags to the respective columns in the automation.
![](https://funnelkit.com/wp-content/uploads/2022/04/7-copy-25-1-1024x576.jpg)
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.
![](https://funnelkit.com/wp-content/uploads/2022/04/purchase-test-738x1024.png)
Now go to Contacts in Automation.
Here you’d be able to see a new active contact for the order you just placed.
![](https://funnelkit.com/wp-content/uploads/2022/04/active-contacts-automation-1024x350.png)
You will see the connected spreadsheet once the task is completed.
The relevant data from the order placed will be updated in the sheet.
![](https://funnelkit.com/wp-content/uploads/2022/04/spreadsheet-enter.png)
And that’s how you set up actions of Google Spreadsheets in FunnelKit Automations.