Add new Google Sheets leads to Mailchimp
by
This trigger fires when a new row is added to a spreadsheet you specify.
Developer info
- API endpoint slug
- google_sheets.new_row_in_spreadsheet
Trigger fields
Path Text input > Other
- Label
- Enter the folder path...
- Helper text
- Use '/' to separate folders, e.g., 'Documents/Photos/Receipts'. Detailed guide here
- Slug
- path
- Required
- true
- Can have default value
- true
Filename Text input > Other
- Label
- and enter the filename
- Helper text
- E.g. Vegetable Recipes
- Slug
- filename
- Required
- true
- Can have default value
- true
Spreadsheet url Text input > Other
- Label
- Or copy and paste the spreadsheet URL
- Helper text
- Must be a valid spreadsheet URL
- Slug
- spreadsheet_url
- Required
- true
- Can have default value
- true
Ingredients
Filename The name of the spreadsheet.
- Slug
- spreadsheet_name
- Filter
- GoogleSheets.newRowInSpreadsheet.Filename
- Type
- String
- Example
- 2018 Trip ideas
Path Path of the new spreadsheet.
- Slug
- path
- Filter
- GoogleSheets.newRowInSpreadsheet.Path
- Type
- String
- Example
- IFTTT/Faves
Spreadsheet url The URL to the spreadsheet on Google Sheets.
- Slug
- spreadsheet_url
- Filter
- GoogleSheets.newRowInSpreadsheet.SpreadsheetUrl
- Type
- Web URL
- Example
- https://docs.google.com/spreadsheets/d/1va_bpHMbOIwbQb77orUzAQVs0ZGsyqHqgeyYXssa6Z0/edit#gid=0
Created at Date and time row was added.
- Slug
- created_at
- Filter
- GoogleSheets.newRowInSpreadsheet.CreatedAt
- Type
- Date with time (ISO8601)
- Example
- 2020-07-08T04:17:06+05:00
Row index The numerical value of the new row.
- Slug
- row_index
- Filter
- GoogleSheets.newRowInSpreadsheet.RowIndex
- Type
- String
- Example
- 4
Column a Value in column A
- Slug
- column_a
- Filter
- GoogleSheets.newRowInSpreadsheet.ColumnA
- Type
- String
- Example
- 1234
Column b Value in column B
- Slug
- column_b
- Filter
- GoogleSheets.newRowInSpreadsheet.ColumnB
- Type
- String
- Example
- $99
Column c Value in column C
- Slug
- column_c
- Filter
- GoogleSheets.newRowInSpreadsheet.ColumnC
- Type
- String
- Example
- Towel
Column d Value in column D
- Slug
- column_d
- Filter
- GoogleSheets.newRowInSpreadsheet.ColumnD
- Type
- String
- Example
- Blue
Column e Value in column E
- Slug
- column_e
- Filter
- GoogleSheets.newRowInSpreadsheet.ColumnE
- Type
- String
- Example
- FREE SHIPPING
Column f Value in column F
- Slug
- column_f
- Filter
- GoogleSheets.newRowInSpreadsheet.ColumnF
- Type
- String
- Example
- FREE SHIPPING
Column g Value in column G
- Slug
- column_g
- Filter
- GoogleSheets.newRowInSpreadsheet.ColumnG
- Type
- String
- Example
- Delivery Date
Column h Value in column H
- Slug
- column_h
- Filter
- GoogleSheets.newRowInSpreadsheet.ColumnH
- Type
- String
- Example
- November 7th, 2017
Column i Value in column I
- Slug
- column_i
- Filter
- GoogleSheets.newRowInSpreadsheet.ColumnI
- Type
- String
- Example
- Delivery Address
Column j Value in column J
- Slug
- column_j
- Filter
- GoogleSheets.newRowInSpreadsheet.ColumnJ
- Type
- String
- Example
- 923 Market St. San Francisco, CA 94117
Column k Value in column K
- Slug
- column_k
- Filter
- GoogleSheets.newRowInSpreadsheet.ColumnK
- Type
- String
- Example
- 923 Market St. San Francisco, CA 94117
Column l Value in column L
- Slug
- column_l
- Filter
- GoogleSheets.newRowInSpreadsheet.ColumnL
- Type
- String
- Example
- 923 Market St. San Francisco, CA 94117
Column m Value in column M
- Slug
- column_m
- Filter
- GoogleSheets.newRowInSpreadsheet.ColumnM
- Type
- String
- Example
- 923 Market St. San Francisco, CA 94117
Column n Value in column N
- Slug
- column_n
- Filter
- GoogleSheets.newRowInSpreadsheet.ColumnN
- Type
- String
- Example
- 923 Market St. San Francisco, CA 94117
Column o Value in column O
- Slug
- column_o
- Filter
- GoogleSheets.newRowInSpreadsheet.ColumnO
- Type
- String
- Example
- 923 Market St. San Francisco, CA 94117
Column p Value in column P
- Slug
- column_p
- Filter
- GoogleSheets.newRowInSpreadsheet.ColumnP
- Type
- String
- Example
- 923 Market St. San Francisco, CA 94117
Column q Value in column Q
- Slug
- column_q
- Filter
- GoogleSheets.newRowInSpreadsheet.ColumnQ
- Type
- String
- Example
- 923 Market St. San Francisco, CA 94117
Column r Value in column R
- Slug
- column_r
- Filter
- GoogleSheets.newRowInSpreadsheet.ColumnR
- Type
- String
- Example
- 923 Market St. San Francisco, CA 94117
Column s Value in column S
- Slug
- column_s
- Filter
- GoogleSheets.newRowInSpreadsheet.ColumnS
- Type
- String
- Example
- 923 Market St. San Francisco, CA 94117
Column t Value in column T
- Slug
- column_t
- Filter
- GoogleSheets.newRowInSpreadsheet.ColumnT
- Type
- String
- Example
- 923 Market St. San Francisco, CA 94117
Column u Value in column U
- Slug
- column_u
- Filter
- GoogleSheets.newRowInSpreadsheet.ColumnU
- Type
- String
- Example
- 923 Market St. San Francisco, CA 94117
Column v Value in column V
- Slug
- column_v
- Filter
- GoogleSheets.newRowInSpreadsheet.ColumnV
- Type
- String
- Example
- 923 Market St. San Francisco, CA 94117
Column w Value in column W
- Slug
- column_w
- Filter
- GoogleSheets.newRowInSpreadsheet.ColumnW
- Type
- String
- Example
- 923 Market St. San Francisco, CA 94117
Column x Value in column X
- Slug
- column_x
- Filter
- GoogleSheets.newRowInSpreadsheet.ColumnX
- Type
- String
- Example
- 923 Market St. San Francisco, CA 94117
Column y Value in column Y
- Slug
- column_y
- Filter
- GoogleSheets.newRowInSpreadsheet.ColumnY
- Type
- String
- Example
- 923 Market St. San Francisco, CA 94117
Column z Value in column Z
- Slug
- column_z
- Filter
- GoogleSheets.newRowInSpreadsheet.ColumnZ
- Type
- String
- Example
- 923 Market St. San Francisco, CA 94117
