Google Sheets
Send data from MESH to Google SpreadSheet
This action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
Developer info
- API endpoint slug
- google_sheets.append_to_google_spreadsheet
- Filter code method
- GoogleSheets.appendToGoogleSpreadsheet.skip(string?: reason)
- Runtime method
- runAction("google_sheets.append_to_google_spreadsheet", {})
Action fields
Filename Text input > Document title
- Label
- Spreadsheet name
- Helper text
- Will create a new spreadsheet if one with this title doesn’t exist
- Slug
- filename
- Required
- true
- Can have default value
- true
- Filter code method
- GoogleSheets.appendToGoogleSpreadsheet.setFilename(string: filename)
Formatted row Text input
- Label
- Formatted row
- Helper text
- Use “|||” to separate cells
- Slug
- formatted_row
- Required
- true
- Can have default value
- true
- Filter code method
- GoogleSheets.appendToGoogleSpreadsheet.setFormattedRow(string: formatted_row)
Path Text input > Path to a folder
- Label
- Drive folder path
- Helper text
- Use '/' to separate folders, e.g., 'Documents/Photos/Receipts'. Detailed guide <a href="https://ift.tt/drivefolderpath" target="_blank">here</a>
- Slug
- path
- Required
- false
- Can have default value
- true
- Filter code method
- GoogleSheets.appendToGoogleSpreadsheet.setPath(string: path)
