Using Google Drive in Agents

After you connect your Google account, the following nodes become available in Profound Agents. Find them in the Agent builder under Google Suite: the Google Docs and Google Sheets groups, and the Google Slides node. Every node runs as the Google account you select under Google Account. It can only reach the files you added through Google’s file picker and the files Profound created, so add the files before you build with them.

New to Agents? See Getting started with Agents in the Profound Help Center.

Available nodes

Create Document

Creates a Google Doc.

Required inputs

Google Account — Select a connected account from the dropdown
Document Title — The title of the new document

Optional inputs

Input	Default	Description
Content format	Plain Text	How to read Initial Content: Plain Text, Markdown, or HTML. Use the format of the content you paste or reference.
Initial Content	-	The content of the new document. Markdown and HTML are converted to formatted text by Google. HTML must contain tags, such as `<p>...</p>`.
Destination folder	My Drive	The Drive folder to create the document in. Select a folder you added through the picker, or select Add a folder from Google Drive to add one. The folder can be in a shared drive. Accepts a variable that holds a folder ID.

Output

A JSON object with the new document’s documentId, document_url, and title.

If Profound can’t write the content into a document it just created in a folder, it moves the empty document to the trash so the folder doesn’t collect blank files.

Create Spreadsheet

Creates a spreadsheet and fills its first sheet with rows, or adds a new sheet with rows to an existing spreadsheet.

Required inputs

Google Account — Select a connected account from the dropdown
Title — The title of the new spreadsheet, or of the new sheet when you add to an existing spreadsheet
Rows — The data to write, in the format selected under Input format
Input format — CSV (selected by default when you add the node), TSV (tab-separated), Markdown table, HTML table, or JSON. JSON accepts an array of objects, whose keys become the header row, an object of arrays keyed by column, or an array of arrays. A code fence around the content is removed before parsing

Optional inputs

Input	Default	Description
Add to Existing Spreadsheet	-	Leave empty to create a new spreadsheet. Select an existing spreadsheet, or paste its URL, to add a new sheet tab named Title instead.
Value input option (under advanced settings)	Formula / number (interpret as typed)	How Google reads the written values. Formula / number interprets formulas and numbers as if you typed them into a cell, for example `=SUM(A1:B1)`. Plain text (no parsing) stores them as text.

Output

For a new spreadsheet, a JSON object with spreadsheetId, spreadsheet_url, and title. For a new sheet, a JSON object with spreadsheetId, spreadsheet_url, sheetId, and sheet_title.

To copy data between sheets, set Input format to the Output format you used in Get Sheet Values. CSV, TSV, HTML, Markdown, and the JSON shapes round-trip.

Get Row

Reads one row from a sheet.

Required inputs

Google Account — Select a connected account from the dropdown
Spreadsheet — Search the spreadsheets you added and select one, or paste its URL
Row selection — Specific row, First row, or Last row
Row number — The row to read when Row selection is Specific row. Matches the row numbers in the spreadsheet

Optional inputs

Sheet name — The sheet tab to read. If omitted, the first sheet is used

Output

A JSON object with row_number, values (the cell values in order), and record. record maps the header names in row 1 to the row’s values, and is null when the row you read is row 1 or the sheet is empty.

Get Sheet Values

Reads a range of cells.

Required inputs

Google Account — Select a connected account from the dropdown
Spreadsheet — Search the spreadsheets you added and select one, or paste its URL

Optional inputs

Input	Default	Description
Sheet name	First sheet	The sheet tab to read.
Range	Whole sheet	An A1 range within the sheet, for example `A1:D10`.
Value render option (under advanced settings)	Formatted value	Formatted value returns values as they’re displayed, Unformatted value returns the underlying values, and Formula returns formulas instead of their results.
Output format (under advanced settings)	Rows (2D array)	The shape of the output: Rows (2D array), Records (list of dicts), Columns (dict of lists), CSV (string), TSV (tab-separated), HTML table, Markdown table, or Raw (full API response). Records, Columns, CSV, TSV, HTML, and Markdown treat the first row of the range as the header.

Output

A JSON object with the data under values, in the selected shape. Raw returns Google’s full response instead, with values and majorDimension.

Records and Columns need unique header names. If two columns share a name, rename one in the spreadsheet or pick another format.

Update Cell

Writes one value to one cell.

Required inputs

Google Account — Select a connected account from the dropdown
Spreadsheet — Search the spreadsheets you added and select one, or paste its URL
Cell — The cell in A1 notation, for example A1
Value — The value to write, as a string, number, or boolean

Optional inputs

Sheet name — The sheet tab to write to. If omitted, the first sheet is used
Value input option (under advanced settings) — Formula / number (interpret as typed) (default) or Plain text (no parsing)

Output

Google’s update response, including the updated range.

Write Row

Appends one row to a sheet, or overwrites one existing row.

Required inputs

Google Account — Select a connected account from the dropdown
Spreadsheet — Search the spreadsheets you added and select one, or paste its URL
Values — A JSON array of cell values that map to columns in order, for example ["Alice", "alice@example.com", 42, true]
Write mode — Append to end (default) adds the row after the last row with data. Overwrite specific row replaces the row you set under Row number
Row number — The row to overwrite when Write mode is Overwrite specific row

Optional inputs

Sheet name — The sheet tab to write to. If omitted, the first sheet is used
Value input option (under advanced settings) — Formula / number (interpret as typed) (default) or Plain text (no parsing)
Start column (under advanced settings) — The column letter to start the row at, for example A or E. If empty, Google detects where the table is when appending, and overwriting starts at column A

Output

A JSON object with updated_range and the row_number that was written.

Write Rows

Appends several rows to a sheet, or updates several existing rows, in one run.

Required inputs

Google Account — Select a connected account from the dropdown
Spreadsheet — Search the spreadsheets you added and select one, or paste its URL
Mode — Add rows (default) appends after the last row with data. Update rows overwrites the rows you name
Row Data Format — Arrays (default) or JSON Objects
Row Data — A JSON array with one entry per row. Its shape depends on Mode and Row Data Format:

Mode	Arrays	JSON Objects
Add rows	Each inner array is one row, mapped to columns in order: `[["Alice", "alice@example.com", 90], ["Bob", "bob@example.com", 85]]`	Keys are column letters: `[{"A": "Alice", "B": "alice@example.com", "C": 90}]`
Update rows	The first element of each row is the row number to update: `[[1, "Alice", "alice@example.com", 95], [3, "Charlie", "charlie@example.com", 88]]`	Each object includes a `row_number` key: `[{"row_number": 1, "A": "Alice", "B": "alice@example.com"}]`

Optional inputs

Sheet name — The sheet tab to write to. If omitted, the first sheet is used
Value input option (under advanced settings) — Formula / number (interpret as typed) (default) or Plain text (no parsing)
Start column (under advanced settings) — The column letter to start rows at, for example A or E. If empty, Google detects where the table is when adding rows, and updates start at column A

Output

A JSON object with rows_created, rows_updated, and updated_range.

Key concepts

Files Profound can reach

Profound holds Google’s drive.file permission, which covers only the files you selected in Google’s file picker and the files Profound created. Each file dropdown lists those files for the selected account, and the Add files from Google Drive action at the bottom of the dropdown opens the picker so you can add more. Files that Profound creates with Create Document and Create Spreadsheet are available to later nodes without adding them.

Selecting a file

The Document, Spreadsheet, and Presentation inputs accept:

A file selected from the dropdown
The file’s URL, such as https://docs.google.com/document/d/<FILE_ID>/edit or https://drive.google.com/open?id=<FILE_ID>
The file’s ID
A variable from a previous node’s output, for example the documentId returned by Create Document

If the value is neither an ID nor a URL, Profound treats it as the file name and looks for an exact match, ignoring case, among the files it can reach. The node stops with an error when no file matches or when more than one does. Use the ID or URL in that case.

Sheets, ranges, and values

Sheet name is the name of a tab in the spreadsheet. Leave it empty to work with the first tab.
Range and Cell use A1 notation, for example A1:D10 or B2. Leave Range empty to read the whole sheet.
Value input option decides how Google stores what you write. Formula / number (interpret as typed) treats =SUM(A1:B1) as a formula and 42 as a number, as if you typed them into the cell. Plain text (no parsing) stores them as text.

Troubleshooting

A node reports that the document, spreadsheet, or presentation isn't found

Profound can only open files you added through the picker or files it created. Check that the file is one of them and still exists in Drive. If you pasted a URL or ID, confirm that it belongs to the same Google account you selected.

A node reports that no file, or more than one file, matches a name

The value you entered isn’t an ID or URL, so Profound searched by name. Select the file from the dropdown, or paste its URL or ID.

A Sheets node reports that a worksheet isn't found

Sheet name must match the tab name in the spreadsheet exactly. Copy it from the spreadsheet, or leave the field empty to use the first tab.

A Sheets node reports that the range is outside the sheet

The error tells you how many rows and columns the sheet has. Use a range within those bounds, or add rows and columns to the sheet first.

Get Sheet Values reports duplicate header names

Records and Columns output formats use the first row as keys, so every header must be unique. Rename the duplicate columns in the spreadsheet, or switch Output format to Rows, CSV, or another format.

Create Spreadsheet reports that the content appears to be a different format

Input format must match the data under Rows. For example, JSON data with Input format set to CSV is rejected. Change Input format to the format of your data.

Create Document reports that the HTML content has no tags

With Content format set to HTML, Initial Content must contain HTML tags, such as <p>...</p>. Wrap the text in tags or switch Content format to Plain Text or Markdown.

Create Document can't find or access the destination folder

If Profound can’t find the folder, select it again through Add a folder from Google Drive.
If Profound doesn’t have access to the folder, select a folder where the connected Google account can add files.
For a folder in a shared drive, the connected account must be a member of the shared drive, and your Google Workspace rules must allow it to add files there.
If the drive or folder is full, free up space or select a folder in another drive.

A node reports that the document or presentation is too large

Profound exports up to 5 MB per document or presentation. Split the file, or read a smaller document.

A node reports that you don't have permission to edit

The connected Google account has view-only access to the file. Ask the file’s owner for Editor access, then run the node again.

A node reports that Google's rate limit or quota was exceeded

Google limits how many requests it accepts in a period of time. Wait, then run the Agent again. If this keeps happening, ask your Google Workspace administrator to review the API quota.

A node reports that the integration needs to be re-authorized

Google no longer accepts Profound’s token for the account. In Settings > Integrations > Google Drive, revoke the connection and connect the account again.

​Available nodes

​Create Document

​Required inputs

​Optional inputs

​Output

​Get Document

​Required inputs

​Optional inputs

​Output

​Create Spreadsheet

​Required inputs

​Optional inputs

​Output

​Get Row

​Required inputs

​Optional inputs

​Output

​Get Sheet Values

​Required inputs

​Optional inputs

​Output

​Update Cell

​Required inputs

​Optional inputs

​Output

​Write Row

​Required inputs

​Optional inputs

​Output

​Write Rows

​Required inputs

​Optional inputs

​Output

​Google Slides

​Required inputs

​Output

​Key concepts

​Files Profound can reach

​Selecting a file

​Sheets, ranges, and values

​Troubleshooting

Available nodes

Create Document

Required inputs

Optional inputs

Output

Get Document

Required inputs

Optional inputs

Output

Create Spreadsheet

Required inputs

Optional inputs

Output

Get Row

Required inputs

Optional inputs

Output

Get Sheet Values

Required inputs

Optional inputs

Output

Update Cell

Required inputs

Optional inputs

Output

Write Row

Required inputs

Optional inputs

Output

Write Rows

Required inputs

Optional inputs

Output

Google Slides

Required inputs

Output

Key concepts

Files Profound can reach

Selecting a file

Sheets, ranges, and values

Troubleshooting