Integrations · Step
Read a Google Sheet
Read cells from a Google Sheet shared by link: rows as a list, and as text.
sheets.read
In a flow
“When a button is clicked, read a Google Sheet.”
/prices → Read a Google Sheet A2:B20 → Reply with As text.
What it does
Read cells from a Google Sheet shared by link: rows as a list, and as text. It's a step: it runs when the white wire reaches it, then the flow carries on from its Then pin. It gives 4 values 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: read cells from a Google Sheet shared by link: rows as a list, and as text.
When not to
If nothing should change in Discord, a value node or a check is lighter.
Typical wiring
Sockets: settings you can wire
- Spreadsheet Text
-
The Google Sheet's link or id. It must be shared as anyone with the link can view.
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, the step runs without it.
Connects fromA member's variablesAccept applicationAdd a Notion pageAdd a Trello cardAdd an emojiAdd to number in objectAdd up timesAdd working daysand 844 more
- Range Text
-
The cells, like Sheet1!A1:C20 or A:B.
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 A1:C20.
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
- Rows List
-
Each row, as a list of its cells. e.g. [["Sam", "120"]]
If it's empty: Empty when the step didn't make one (it stopped early or was skipped); steps reading it get nothing.
Connects toAdd onboarding questionAdd to listAdd up timesAutoMod: add or remove allowed wordsAutoMod: add or remove wordsAutoMod: block wordsBar chartBest by a fieldand 88 more
- Rows found Number
-
How many rows. e.g. 12
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
- First cell Text
-
The top-left cell. e.g. Sam
If it's empty: Empty when the step didn't make one (it stopped early or was skipped); steps reading it get nothing.
Connects toAccept applicationAdd a forum tagAdd a labelAdd a Notion pageAdd a row to a Google SheetAdd a staff noteAdd a stickerAdd a Trello cardand 577 more
- As text Text
-
It written out, ready to post. e.g. …
If it's empty: Empty when the step didn't make one (it stopped early or was skipped); steps reading it get nothing.
Connects toAccept applicationAdd a forum tagAdd a labelAdd a Notion pageAdd a row to a Google SheetAdd a staff noteAdd a stickerAdd a Trello cardand 577 more