Google Sheets and HubSpot

Google Sheets

Triggers

• Google Sheets New RowTriggers when a new row is added to a Google Sheets spreadsheet.

Actions

• Append rowAppend a single row to the end of a Google Sheet.
• Create spreadsheetCreate a new Google Sheets spreadsheet.
• Delete spreadsheetDelete a Google Sheets spreadsheet permanently.
• Write rowOverwrite a whole row, from column A, with values in column order. To change only some cells of a row, use Update row.
• Update rowSet some cells of one row by column name, leaving the rest of the row as it is. Pair it with Read rows to write a result back to the row it came from. A column that doesn't exist yet is added to the header row.
• Clear row valuesClear values in a specific row without deleting the row itself.

HubSpot

Triggers

• New HubSpot contactRuns when a contact is created in HubSpot, by a form, an import, a person or another app.
• New HubSpot dealRuns when a deal is created in HubSpot, in any pipeline.
• HubSpot deal reached a stageRuns when a deal enters the stage you choose in HubSpot, such as Closed won, however long ago the deal was created. A deal that leaves the stage and comes back runs it again.
• New HubSpot form submissionRuns when someone submits a HubSpot form. Needs the forms scope on the service key, as well as the ones the connect steps list.

Actions

• Create a HubSpot contactCreate a new contact with email, name, phone, and company details. HubSpot de-duplicates contacts on the email address.
• Find contact by emailLook up a HubSpot contact using an email address. Fails the step when no contact has that address.
• Update a HubSpot contactChange the details of an existing HubSpot contact, such as their name, phone number, or company.
• List HubSpot contactsList a page of HubSpot contacts for quick review. These come back in record-id order (oldest first) and cannot be filtered; use 'Find contacts created in a date range' to report on recent leads.
• Find contacts created in a date rangeFind HubSpot contacts created on or after a date, newest first. Returns the matching contacts plus the total number that match, so a report can count every new lead in the window.
• Delete a HubSpot contactArchive a HubSpot contact. HubSpot archives rather than destroys: the record leaves the CRM and the API, and stays restorable from the portal's recycling bin for 90 days.