Read, write, manage, and style Google Sheets spreadsheets in workflows.

The Google Sheets integration lets Foqal read data from and write data to spreadsheets in your Google account. Workflows and AI agents can fetch entire spreadsheets, individual pages (tabs), specific columns, rows, or single cell values; append new rows; update individual cell values; create new pages and spreadsheets; rename them; delete pages or whole spreadsheets; and style cells (fonts, colors, bold/italic/underline, number formats) or apply borders and grid lines. When connecting, you'll sign in with Google and approve access so Foqal can read, update, manage, and remove the sheets you choose to use in your workflows.

Available Actions
‍

Append rows

Append one or more rows of data to a page in a Google Sheets spreadsheet.

Apply borders

Apply or remove borders / grid lines on a range of cells, a column, a row, or both on a Google Sheets page.

Batch clear values

Clear values from multiple A1 ranges in a single call (formatting is preserved).

Batch update spreadsheet

Power-user pass-through to spreadsheets.batchUpdate. Apply an arbitrary array of Sheets API Request objects atomically.

Batch update values

Update many disjoint A1 ranges in a single call. Each entry specifies its own range and 2D values array.

Clear range

Clear all values from a single A1 range on a Google Sheets spreadsheet (formatting is preserved).

Create page

Create a new page (tab) on an existing Google Sheets spreadsheet.

Create spreadsheet

Create a brand new Google Sheets spreadsheet.

Delete page

Delete a page (tab) from an existing Google Sheets spreadsheet.

Delete spreadsheet

Delete a Google Sheets spreadsheet. The spreadsheet is moved to the Drive trash.

Find and replace

Find and replace text across an entire spreadsheet or within a single page.

Format cells

Update the formatting (font, color, background, bold/italic/underline, number format) of cells, a column, a row, or a range on a Google Sheets page.

List pages

List every page (sheet/tab) on a Google Sheets spreadsheet along with its numeric sheetId, title, position, hidden flag, and grid dimensions.

Read range

Read a single A1-notation range from a Google Sheets spreadsheet (e.g. 'A:A', 'A1:B5', '1:3', or with a sheet prefix like 'Sheet1!A:14') and return the cell values as a 2D array.

Read spreadsheet

Read data from a Google Sheets spreadsheet. Returns the entire spreadsheet, a single page, a column, a row, or a single cell as JSON depending on which inputs are provided.