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.
Step 2: Click on the Google sheets icon
Step 3: Select an event
Step 4: Click on Add Account to add your Google Sheets account.
Step 5: Authorize Stargate to use Google Sheets
Step 6: Copy the Google Sheets code to the clipboard
Step 7: Paste the code into Stargate
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.
Step 9: Select a sheet in the spreadsheet
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.
Step 11: Click on Save to save the layout to the server
Step 12: Click on Test this step to execute