In this article, you will learn how to integrate your Google Sheets account with your SystemeScale account.
What you need to know
SystemeScale makes managing your data easier with its Google Sheets integration. You no longer need external services like Zapier to connect your forms or automations to Google Sheets. You can now do it directly from your SystemeScale dashboard.
π
What this integration helps you do
Once connected, you can automatically add data to a Google Sheets worksheet from workflows based on the triggers you define.
How to set up the integration with Google Sheets
The setup is quick and simple. In a few steps, you can connect your Google account and start automating your business using Google Sheets.
1
Open Settings
Click your profile picture, then go to Settings.
2
Open Integrations
Scroll down the menu on the left to the Integrations section, then click it.
3
Select Google Sheets
Select Google Sheets from the list of available integrations to connect your account.
4
Start the connection
A popup will appear. Click Connect to begin the integration.
5
Choose your Google account
In the next window, select the Google account you want to use.
6
Continue authorization
Click Continue to allow Google to share the required information with SystemeScale.
7
Grant specific file access
Check the box labeled See, edit, create, and delete only the specific Google Drive files you use with this app, then click Continue.
8
Confirm the connected account
After authorization, your Google account will appear in the SystemeScale interface.
9
Manage connected accounts
Once connected, you can view account details, disconnect the current account, or add new Google accounts.
β
Multiple Google accounts supported
You can integrate multiple Google accounts into your SystemeScale account and choose the correct drive when setting up your workflow action.
Available features with Google Sheets integration
Once the integration is set up, you can use the workflow action Add a new row to a Google Sheet. This allows you to automatically add data to a Google Sheets worksheet based on triggers you define in your workflows.
βοΈ
Need to create the workflow first?
Use workflows when you need to add Google Sheets actions after specific triggers, decisions, or delays.
How to add a new row to a Google Sheet from a workflow
After connecting your Google account, add the Google Sheets action inside a workflow.
1
Select the workflow action
In your workflow, choose the action Add a new row to a Google Sheet.
2
Choose a drive
If you have multiple integrated Google accounts, select the Google Drive you want to use.
3
Add a Google file
Select the specific Google Sheet you want to use from the list.
4
Select the file
Choose your desired file, then click Select.
β οΈ
Column headers are required
Make sure your worksheet already contains column headers, because the current integration does not support creating new Google Sheets from scratch.
5
Choose a worksheet
Google Sheets files can contain multiple worksheets, so choose the specific worksheet where you want to add data.
6
Map your data
Assign your data fields to the corresponding columns of your Google Sheet. This lets you decide which data goes in which column and keeps your file organized.
7
Create the action
Once you have mapped your data fields, click Create to save the workflow action.
Mapping multiple data fields to the same column
It is possible to map two or more types of data to the same column.
π‘
Example: Full Name column
You can create a column titled Full Name, then map both First Name and Surname to that same column so both values are added together in the Google Sheet.
Once you complete these steps, your data will be automatically saved in your Google Sheet without needing another intermediary platform.
Test your Google Sheets workflow action
After completing the setup in Data Mapping, go to the Tests section to verify that your automation works correctly.
1
Open Tests
Go to the Tests section of the workflow action.
2
Run the test
Click Test to start the test.
3
Confirm completion
You will see a message indicating that the test has been completed.
4
Check the Google Sheet
After running the test, a new row containing the test data should be added to your Google Sheet.
β
Use testing before going live
Testing helps confirm that the correct worksheet, columns, and mapped fields are working before real contacts enter the workflow.
Important notes
- The action Add a new row to a Google Sheet is only available in workflows. It is currently not possible to do this with a simple automation rule.
- You can integrate multiple Google accounts into your SystemeScale account.
- The dates provided to your Google Sheets use the format
YYYY-MM-DD HH:MM:SS, taking into account the userβs time zone. For example: 2025-02-26 17:55:30. - The creation and editing of Google Actions for Workspace assistants are disabled. Only the account owner can perform these actions, ensuring better security for integrations and exclusive control over their use.
π§©
Workflows only
Use workflows for Google Sheets row creation. Simple automation rules do not currently support this Google Sheets action.
π
Comparing workflows and automation rules?
Review automation rules if you need simpler trigger-and-action automation, and workflows when you need Google Sheets, branching, delays, or advanced logic.
