Skip to content
Workflows

Add data to Google Sheets with workflows

Last updated: May 10, 2021

Applies to:

Marketing Hub  Professional, Enterprise
Sales Hub  Professional, Enterprise
Service Hub  Professional, Enterprise
Operations Hub  Professional

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.
  • To edit an existing workflow, hover over the workflow, then click Edit. Or, learn how to create a new workflow.
  • In the workflow editor, click the + plus icon to add an action. 

    add-an-action
  • In the actions panel, select Create Google Sheet row.
     workflow-trello-create-google-sheets-row-action
  • 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.