Integrations · Step
Add a row to a Google Sheet
Add a row to the bottom of a Google Sheet through a small Apps Script web app (Extensions > Apps Script: function doPost(e){SpreadsheetApp.getActiveSheet().appendRow(JSON.parse(e.postData.contents).row)} — deploy as a web app anyone can use).
sheets.append
In a flow
“When a button is clicked, add a row to a Google Sheet.”
Application sent → Add a row to a Google Sheet {user.name} | {answer.age}.
What it does
Add a row to the bottom of a Google Sheet through a small Apps Script web app (Extensions > Apps Script: function doPost(e){SpreadsheetApp.getActiveSheet().appendRow(JSON.parse(e.postData.contents).row)} — deploy as a web app anyone can use). It's a step: it runs when the white wire reaches it, then the flow carries on from its Then pin. It gives 1 value later steps can use. Find it under Integrations in the palette.
When to use it
Use it to use another service, like GitHub, the weather or Twitch: add a row to the bottom of a Google Sheet through a small Apps Script web app (Extensions > Apps Script: function doPost(e){SpreadsheetApp.getActiveSheet().appendRow(JSON.parse(e.postData.contents).row)} — deploy as a web app anyone can use).
When not to
If nothing should change in Discord, a value node or a check is lighter.
Typical wiring
Sockets: settings you can wire
- Row Text
-
The row's cells with | between, like {user.name} | {answer.age} | {now.date}.
What goes there: Type it in the side panel, or wire in text. e.g. Hello there
If it's empty: Optional. Left empty and unwired, it uses {user.name} | {now.date}.
Connects fromA member's variablesAccept applicationAdd a Notion pageAdd a Trello cardAdd an emojiAdd to number in objectAdd up timesAdd working daysand 844 more
Values it gives
- Cells Number
-
How many cells the row had. e.g. 3
If it's empty: Empty when the step didn't make one (it stopped early or was skipped); steps reading it get nothing.
Connects toAccount ageActive membersAddAdd answer to formAdd soundboard soundAdd timeAdd to a counterAdd to a leaderboardand 718 more