Add data to Google Sheets with workflows
Last updated: April 9, 2021
Use the Create Google Sheet row action to send data from HubSpot properties to your spreadsheet. Each action can add up to 10 cells of data per row. For example, you can use this action to send contact data from new leads to a spreadsheet for your sales outreach team.
Please note: when sending data to Google Sheets, HubSpot sends internal property values. For dates, HubSpot sends unix timestamps in milliseconds. To convert dates from milliseconds, you can add the following formula to a separate column in the spreadsheet: =A1/1000/60/60/24 + DATE(1970,1,1). Replace A1 with the column that the unix timestamp is in.
Before you can add data to Google Sheets with workflows, you'll need to connect Google Sheets to your HubSpot account. You can connect the app from the App Marketplace or from within a workflow.
To add data to Google Sheets in a workflow:
- In your HubSpot account, navigate to Automation > Workflows.
- Click the name of an existing workflow, or create a new workflow.
- In the workflow editor, click the plus icon + to add a workflow action.
- In the actions panel, select Create Google Sheet row.
- In the Spreadsheet dropdown menu, select the spreadsheet you want to add data to.
- In the Sheet dropdown menu, select which sheet you want to add data to. The Sheet field refers to the tabs at the bottom of your spreadsheet.
- In the Header and Property dropdown menus, select which columns you'll be adding data to and which properties you'll send data from. You can add up to 10 per action.
- Click Save.
Related content
-
Set your workflow enrollment triggers
Set workflow enrollment triggers to automatically enroll records into your workflow when they meet specific...
Knowledge Base -
Create workflows
With the workflows tool, you can automate your marketing, sales, and service processes to make your team more...
Knowledge Base -
Choose your workflow actions
After creating your workflow and setting your enrollment triggers, choose the actions for your workflow....
Knowledge Base