Record new contact information registered in HubSpot into a Google Spreadsheet.
Record new contact information registered in HubSpot into a Google Spreadsheet.
Launch this workflow to connect
HubSpot &
Google Sheets
!
■Overview
New contact information registered in HubSpot will be recorded in a specified Google Spreadsheet.
It is possible to automatically transfer basic information such as the contact's name, email address, and phone number without accessing the spreadsheet.
■Preparation
Prepare a spreadsheet in advance with specified column names to store HubSpot information.
■Setup Method
① Select HubSpot from the app trigger, perform the following settings, and test and save.
・Action: Select "When a new contact is created".
・Trigger interval: Set to 5 minutes.
② Press the + mark, select the spreadsheet from the operation to manipulate the database, perform the following settings, and test and save.
・Action: Select "Add a record".
・Spreadsheet ID: Select the ID of the prepared storage spreadsheet from the options.
・Spreadsheet tab name: Select the target sheet name from the options.・Table range: Select the entire range including column names. For example, if column names are entered from A1 to E1, set it as A1:E
.
・Values of the records to be added: Embed using the output obtained in ① corresponding to the displayed column names.
※ For the definition of the range of spreadsheet operations, see here. https://intercom.help/yoom/en/articles/8703465
※ Common error causes when manipulating the database are here. https://intercom.help/yoom/en/articles/5521559
※ For detailed settings on dynamically embedding output, please refer here. https://intercom.help/yoom/en/articles/8223528
■Notes
・It is necessary to set the account information to be linked in each app's operation.
・For integration (My App Registration), please refer here https://intercom.help/yoom/en/collections/3041779
・Please replace the information in the Google Spreadsheet with any desired values for use.
Check Out Similar Templates!
Create a contract in Google Docs from Hubspot deal information
This is a flow for creating contracts in Google Docs from Hubspot deal information. By eliminating the need to manually transfer Hubspot data, it reduces the time spent on reviewing and editing after creation, thereby streamlining operations.
Create an invoice from the contact page in HubSpot and send an email to Outlook.
Launch the Yoom Flowbot from the HubSpot contact page to create an invoice based on a Microsoft Excel template and send an email in Outlook. By launching the Flowbot from HubSpot and setting information such as billing items and amounts in specified locations, invoices are automatically generated. The invoice template can be used in any format. Additionally, it is possible to include a request for confirmation from the person in charge during the flow, allowing for combinations such as checking the billing details once.
See more
About the Apps
HubSpot
Templates using
HubSpot
Add a contact to HubSpot based on the form information and register an event in Google Calendar.
The workflow automatically adds contacts from form inputs to HubSpot and registers events in Google Calendar. This streamlines lead management and scheduling, saving work time.
When a HubSpot form is submitted, a GitHub Issue is created. This flow allows you to create a GitHub Issue whenever a HubSpot form is submitted. It eliminates the need for manual input and significantly reduces working time.
When a new video is released on YouTube, a flow is created to generate a ticket in HubSpot. This allows for real-time sharing of task progress and response status, reducing miscommunication and enabling smooth business operations.
Templates using
Google Sheets
A workflow to generate invoices using Google Sheets with the information entered in the form, and send them after approval.
Once the billing information is filled out in the form, an invoice will be generated using the Google Spreadsheet invoice template. After that, it will undergo approval by the person in charge, and an email will be sent.
This is a flow for adding order information to WooCommerce when a row is added in Google Sheets. This flow significantly reduces manual effort and saves the time previously spent on registration, allowing you to focus on more important tasks and improving productivity.
You can add a new tab to a Google Spreadsheet at the beginning of each month. By being able to add a new sheet to a specific Google Spreadsheet at the start of each month, you can avoid forgetting to add sheets and prevent unnecessary rework.
About the apps you use
HubSpot
Yoom allows you to integrate with HubSpot's API without any code, enabling the automation of various tasks. You can automatically register contact and company information in HubSpot, and trigger the transfer of information to various SaaS platforms like kintone, spreadsheets, and CloudSign when information is registered or updated in HubSpot. Additionally, you can automatically sync HubSpot's contact and company information to Yoom's database for various uses.
see detailsTemplates
Add a contact to HubSpot based on the form information and register an event in Google Calendar.
The workflow automatically adds contacts from form inputs to HubSpot and registers events in Google Calendar. This streamlines lead management and scheduling, saving work time.
Add a contact to HubSpot based on the form information and register an event in Google Calendar.
When a HubSpot form is submitted, a GitHub Issue is created. This flow allows you to create a GitHub Issue whenever a HubSpot form is submitted. It eliminates the need for manual input and significantly reduces working time.
Create a GitHub Issue when a HubSpot form is submitted.
When a new video is released on YouTube, a flow is created to generate a ticket in HubSpot. This allows for real-time sharing of task progress and response status, reducing miscommunication and enabling smooth business operations.
Create a HubSpot ticket when a video is published on YouTube.
Google Sheets
At Yoom, you can utilize the Google Sheets API without any coding. By integrating Sheets with Yoom, you can automate data entry into spreadsheets and automatically create documents based on spreadsheet templates. Additionally, you can sync spreadsheet information with Yoom's database for various applications.
see detailsTemplates
A workflow to generate invoices using Google Sheets with the information entered in the form, and send them after approval.
Once the billing information is filled out in the form, an invoice will be generated using the Google Spreadsheet invoice template. After that, it will undergo approval by the person in charge, and an email will be sent.
A workflow to generate invoices using Google Sheets with the information entered in the form, and send them after approval.
This is a flow for adding order information to WooCommerce when a row is added in Google Sheets. This flow significantly reduces manual effort and saves the time previously spent on registration, allowing you to focus on more important tasks and improving productivity.
Add order information to WooCommerce when a row is added in Google Sheets.
You can add a new tab to a Google Spreadsheet at the beginning of each month. By being able to add a new sheet to a specific Google Spreadsheet at the start of each month, you can avoid forgetting to add sheets and prevent unnecessary rework.
Add a new tab to the Google Spreadsheet at the beginning of each month.
No-Code API Actions
Executable API actions
Flowbot triggers
When a new contact is created
When a new company is created
When a new deal is created
When a contact is created or updated
When a company is created or updated
When a deal is created or updated
When a form is submitted
When a product is created
When a product is created or updated
When a deal is updated to the specified stage
When a record is created in a custom object
When a record in a custom object is created or updated
When an order is created or updated
When an order is created
When a ticket is created
When a ticket is created or updated
When a service record is created
When a service record is created or updated
Flowbot operations
Create contact
Get contact
Get latest contact IDs
Update contact
Search contacts (keyword search)
Create company
Get company information
Get latest company IDs
Update company
Search companies (keyword search)
Create deal
Get deal information
Get latest deal IDs
Update deal
Search deals (keyword search)
Get contact custom properties
Get company custom properties
Get deal custom properties
Flowbot triggers
When a new contact is createdWhen a new company is createdWhen a new deal is createdWhen a contact is created or updatedWhen a company is created or updatedWhen a deal is created or updatedWhen a form is submittedWhen a product is createdWhen a product is created or updatedWhen a deal is updated to the specified stageWhen a record is created in a custom objectWhen a record in a custom object is created or updatedWhen an order is created or updatedWhen an order is createdWhen a ticket is createdWhen a ticket is created or updatedWhen a service record is createdWhen a service record is created or updatedWhen a task is createdWhen a note is added to a dealWhen a message in the specified thread receives a reply
Flowbot operations
Create contactGet contactGet latest contact IDsUpdate contactSearch contacts (keyword search)Create companyGet company informationGet latest company IDsUpdate companySearch companies (keyword search)Create dealGet deal informationGet latest deal IDsUpdate dealSearch deals (keyword search)Get contact custom propertiesGet company custom propertiesGet deal custom propertiesGet list of contact IDsGet list of company IDsSearch deals (filtered search)Update contact custom propertyUpdate company custom propertyUpdate deal custom propertyCreate ticketSubmit data to formUpdate ticketAssociate recordsAdd note to contactGet public file URLGet custom object recordCreate custom object recordUpdate custom object recordSearch custom object records (keyword search)Get productCreate productUpdate productSearch products (keyword search)Update ticket custom propertyAdd note to companyAdd note to dealAdd note to ticketAdd meeting to companySearch contacts (filter conditions)Get ticket detailsAdd line item to dealSearch products (filter search)Get owner (assignee) informationGet owners (assignees) listSearch multiple companies (filter criteria)Add note to custom object recordGet company IDs associated with a specific contactGet custom object record IDs associated with a specific dealCreate userGet service custom propertiesCreate meeting logGet ticket custom propertiesGet quoteUpdate quoteCreate taskDelete quoteSearch quotesCreate formCreate call logGet tax rate listSearch line items (filter search)Search fees (filter search)Search discounts (filter search)Search quote templates (filter search)Add signers to quoteCreate quoteGet deal line itemsGet line item detailsGet tasks listGet taskGet object associationsGet user detailsSearch users (keyword search)Search users (filter search)Get subscription definitions listSearch multiple tickets (filter criteria)Get pipeline stages listGet pipeline stageGet list of notes associated with a contactSearch custom object records (filtered search)Get product item custom propertiesCreate association between custom objectsCreate record association between ticket and custom objectGet list of inbox threadsRun CRM data export taskGet export task status and file URLDownload export fileCreate custom object record (associate with deal record)
Flowbot triggers
When a row is addedWhen a row is updated
Flowbot operations
Set a value in a cellGet valuesClear valuesCreate a new spreadsheetCopy a sheet (tab)Add a new sheet (tab)Delete Sheet (Tab)Replace valuesUpdate Sheet NameDelete RowsGet Spreadsheet InfoGet sheet namesApply a formula to a rangeEnter values in a rangeEmbed an image in a cellSort by specific columnHide a sheetAdd a note to the specified cellsInsert columnsDelete columnsWrite values to multiple columnsMore inspiration for you
Discover step-by-step guides for automating your work using the apps featured in this workflow!
