Action

Google Sheet / Doc (read)

Read a shared sheet/doc

Google Sheet / Doc (read) pulls rows or content from a Google Sheet or Google Doc you have shared, so a workflow can run on data you already keep in Google. No copying or re-uploading: it reads the file where it lives.

How it works

Share a Sheet or Doc with dojobase and this node reads straight from it. Rows from a Sheet become records for the workflow to work through; the text of a Doc becomes content the later steps can use.

It suits teams whose real source of truth is a spreadsheet. Your list of clients, orders, or applicants lives in Google and gets edited there all day; this node lets a workflow act on that exact list without anyone exporting a file.

Because it reads the live file, each run reflects whatever the Sheet or Doc says at that moment. Update a row in Google and the next job sees the change, which pairs naturally with running on a schedule.

Common use cases

Real situations where this node earns its place in a flow.

A shared sheet as your queue

Read new rows from a Google Sheet your team already keeps and run each one through a workflow.

Pull text from a doc

Read a Google Doc's content into a flow to reformat, analyze, or route it.

Let the client own the data

Let a customer keep working in their own spreadsheet while your workflow reads it on a schedule.

Google Sheet / Doc (read) in a workflow

A simple example of where this node sits in a flow.

What you set up

Share the specific Google Sheet or Doc with dojobase.
Pick the tab or range of rows to read from a Sheet.
Choose which columns or content the workflow should use.

Common questions

Does it change my Google file?

No. It only reads. To write results back to Google, add the matching Google output node.

Will it see edits I make in the Sheet?

Yes. It reads the live file, so each run uses whatever the Sheet or Doc contains at that time.

Settings you configure on this node, stored under data.config in the workflow JSON. Leave a field unset to use its default.

Field	Type	Default	What it controls
`sourceUrl`req	string	—	URL of the shared Google Sheet or Doc to read.
`range`	string	—	Sheets A1 range to read (e.g. Sheet1!A1:F); blank reads the whole first tab.
`headerRow`	boolean	`true`	When on, row 1 becomes column names and each row a record; off returns the raw grid.
`exportAs`	enum: text \| html	`text`	Format for reading a Doc's contents; ignored for Sheets.
`recordLimit`	number	—	Maximum sheet rows to read (default 500, max 5000).

sourceUrlreq
URL of the shared Google Sheet or Doc to read.
Type: string
range
Sheets A1 range to read (e.g. Sheet1!A1:F); blank reads the whole first tab.
Type: string
headerRow
When on, row 1 becomes column names and each row a record; off returns the raw grid.
Type: booleanDefault: true
exportAs
Format for reading a Doc's contents; ignored for Sheets.
Type: enum: text | htmlDefault: text
recordLimit
Maximum sheet rows to read (default 500, max 5000).
Type: number

How this node appears inside a workflow's nodes[] array (the shape you see in the Developer export / import). A full workflow is { nodes: [...], edges: [...] }.

{
  "id": "gdrive-in",
  "type": "card",
  "position": {
    "x": 160,
    "y": 120
  },
  "data": {
    "type": "gdrive-in",
    "kind": "processor",
    "title": "Google Sheet / Doc (read)",
    "subtitle": "Read a shared sheet/doc",
    "config": {
      "sourceUrl": "",
      "range": "",
      "headerRow": "true",
      "exportAs": "text",
      "recordLimit": "0"
    }
  }
}