Send new HubSpot contacts to Google Sheets and Slack
Set up an automation: every new HubSpot contact is added as a row to my Google Sheet and posted in a Slack channel
Build itIt builds an automation and asks before each Slack post.
How to send HubSpot contacts to Google Sheets and Slack
Paste the ask. Captain asks which spreadsheet and tab, which Slack channel, and which contact fields you want as columns.
CaptainSet up an automation: every new HubSpot contact is added as a row to my Google Sheet and posted in a Slack channel
I’ll set that up. A couple of quick questions first.
A new contact in HubSpot, a row in Google Sheets, a post in Slack. You see each step and its settings before anything is built.
Contacts to Sheet and SlackAutomation · each new contact, logged and shared- Runs
- When a contact is created in HubSpot
- Does
- Reads the new contact's fields · Adds a row to your sheet · Posts it in your Slack channel
- Uses
HubSpot
Google Sheets
Slack- Asks first
- Each Slack post
Connect HubSpot, Google Sheets and Slack. Captain reads your sheet's header row and matches each column to a contact field.
HubSpotConnected
Google SheetsConnect
SlackConnectA contact is created, the automation adds one row under your headers, and the Slack message is prepared with the same details.
Contacts to Sheet and SlackLive- Today, 10:41Added Dana Whitfield as row 48, Slack post waiting
- Today, 9:12Added Marcus Lee as row 47, post approved
- Yesterday, 16:05Added Ana Ruiz as row 46, post approved
Example runs
The post waits in Needs you with the channel and the text. Approve and post, change it, or decline it.
Contacts to Sheet and Slack asks youNeeds youPost in Slack, #new-leadsNew contact: Dana Whitfield (Brightline Physio), [email protected].
Lifecycle stage: Lead. Owner: Sam Patel.
Approve and postChangeDecline
Works with HubSpot, Google Sheets, Slack and 2,300+ apps
Make it yours
Change one thing, and Captain builds that version instead.
- “Set up an automation: every new HubSpot contact in the United States is added as a row to my Google Sheet and posted in a Slack channel”Only contacts in the United States
- “Set up an automation: every new HubSpot contact is added as a row to my Google Sheet and posted in a Discord channel”Posts in Discord, not Slack
- “Set up an automation: every new HubSpot contact is added as a record to my Airtable base and posted in a Slack channel”Records go to Airtable, not Sheets
- “Set up an automation: every new HubSpot contact is added as a row to my Google Sheet”Sheet only, nothing to approve
Questions people ask
Can HubSpot send new contacts to Google Sheets without Zapier?
Yes, with a workflow on a Professional or Enterprise plan. On a free or Starter plan you need a tool outside HubSpot, such as this automation.
Will it post in Slack without asking me?
No. An automation's post to a Slack channel waits in Needs you until you approve it. The row in your own sheet goes in on its own.
Does it add contacts that already exist in HubSpot?
No. It starts on each new contact from the moment it is live, so older contacts are not added. Export them from HubSpot and paste or drop the file in a sheet if you need them.
What if I want the row to update when a contact changes?
This automation adds a row when a contact is created. For changes, ask Captain for a second automation that updates the row, using Google Sheets' lookup and update actions.
Can it post to a private Slack channel?
Yes, once you invite the Slack app to that channel. Slack only lists private channels the app belongs to.
What does it cost to start?
50agents is free to start. Describe the automation to Captain, check each step and its settings, and tap Build it.
What if a row lands in the wrong column?
Captain matches columns by reading your sheet's header row. Rename a heading in row one and ask Captain to rebuild the match, and new contacts follow it.
Can it send contacts to Airtable or another tool?
Yes. A variation on this page writes to an Airtable base, and 50agents works with 2,300+ apps through viaSocket. Name the app you use in your sentence to Captain.
How long does setup take?
One sentence to Captain, then you connect HubSpot, Google Sheets and Slack and pick the sheet. The automation runs from the next new contact once it is built.
More things Captain can build
Send new HubSpot contacts to Google Sheets and Slack
One sentence to Captain. Free to start.
Build it with Captain