Google Sheets
In Marqvia, we have already integrated with Google Sheet. With this function, you will be able to seamlessly collect any attribute data into a Google Sheet without any further settings needed.
How to Activate Google Sheet Integration
Go into Settings in Marqvia and navigate into Integration.
Now, select Google Sheet.
Press Save.
Ensure that this is enabled.
How to Use Google Sheet in an Automation
Here is a simple guide to use this integration in an automation.
Add the Node
When you open an automation, you can go into the action button and scroll down to see a new node called "add new row in Google Sheet".
Open Node Settings
Double-click on the node to open its settings.
Fill in Node Details
Now, you will need to fill up the details of the node settings.
Google Service Account: This is an auto-generated service account that is used to give Marqvia access to write data into your Google Sheet. You will need to grant an Editor role access to this Google Service Account.
Google Sheet Url: Enter the link to your Google Sheet here. Marqvia will send and add new data into this sheet.
Google Drive Url: Enter the link to your Google Drive folder here. This is only needed if you have any fields that collect file uploads—the uploaded files will be stored in this Drive folder.
Map Data to Columns
Now, you need to map the Attribute data to your Google Sheet column name.
Click the "Source Attribute" dropdown to select which attribute data you want to send to the Google Sheet.
Then, type the corresponding column header name into the "Google Sheet Column Name" field.
You can ignore the Field Type section.
Add a Timestamp (Optional)
You can add a timestamp to your Google Sheet to log when each data entry is added.
To do this, scroll to the bottom until you see the section of "Auto Add Timestamp in Sheet" and enter the header name of the column where you want the timestamp to appear.
Save Settings
Click Update Node to save the settings.
Last updated