Google sheets

 

 

What this page contains


Which Google sheets Triggers and Actions are Supported?

Supported Triggers

There are currently no supported triggers

Supported Actions

  • Create Spreadsheet Row - Create a new row in a specific sheet on a spreadsheet.


How to Get Started with Google sheets on Stargate

To connect a trigger to Google sheets, you first need to set up a trigger. In this case we are going to use Gmail as the trigger. That means as soon as an email lands in Gmail, Stargate breaks it down and send the information to Google sheets.


Step 1: You need to click on the New action button to create a Google sheets action.

Get started with adding your account!



Step 2: Click on the Google sheets icon

Get started with adding your account!



Step 3: Select an event

Get started with adding your account!



Step 4: Click on Add Account to add your Google Sheets account.

Get started with adding your account!



Step 5: Authorize Stargate to use Google Sheets

Get started with adding your account!



Step 6: Copy the Google Sheets code to the clipboard

Get started with adding your account!



Step 7: Paste the code into Stargate

Get started with adding your account!



Step 8: Select a spreadsheet from the dropdown

Then enter the message.  The fields from Gmail are shown on the left. You can drag and drop any of the Gmail fields on the left and drop it in the message.

These dropped fields will be replaced with the real values at runtime.

Get started with adding your account!



Step 9: Select a sheet in the spreadsheet

Get started with adding your account!



Step 10: The fields of Gmail and Google sheets are displayed next to each other

Important: In order for fields to have  names you need to follow the requirements for this step

Drag and drop fields that you need to link.

Get started with adding your account!



Step 11: Click on Save to save the layout to the server

Get started with adding your account!



Step 12: Click on Test this step to execute

Get started with adding your account!