Automate Google Sheets

Split by object

Split Out

Fetch properties from Hubspot

HTTP Request

Define crm_type

Code

Split results

Split Out

Transforms the results

Code

Append to Google sheet

Google Sheets

Erase Google sheet

Google Sheets

Sticky Note

Sticky Note

Sticky Note1

Sticky Note

Define array of objects

Set

Start here to update your field list

Manual Trigger

File upload form

Form Trigger

To get the first line of file

Extract From File

Set the real fields

Set

Get the fields from the sheet

Google Sheets

Merge fields and data

Merge

Check if all fields from input are defined

Code

If all fields are defined

If

Creates the correspondance table

Code

Form to set the correponding field for each input field

Form

Get the content of file

Extract From File

Sticky Note2

Sticky Note

Split all records to import

Split Out

Define properties

Set

Uploads to Hubspot

HTTP Request

Form response

Form

Remove hidden and starting with hs_ props fields

Filter

Sticky Note3

Sticky Note

Sticky Note4

Sticky Note

Set the values for each field

Code

Set the values for each field1

Code

Sticky Note5

Sticky Note

Sticky Note7

Sticky Note

Sticky Note6

Sticky Note

Sticky Note8

Sticky Note

Sticky Note9

Sticky Note