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.
Automate these workflows and actions through the Foqal + Google Sheets integration.
Append one or more rows of data to a page in a Google Sheets spreadsheet.
Apply or remove borders / grid lines on a range of cells, a column, a row, or both on a Google Sheets page.
Clear values from multiple A1 ranges in a single call (formatting is preserved).
Power-user pass-through to spreadsheets.batchUpdate. Apply an arbitrary array of Sheets API Request objects atomically.
Update many disjoint A1 ranges in a single call. Each entry specifies its own range and 2D values array; bounded ranges are auto-expanded to fit the submitted matrix.
Other integrations that work great with Foqal.
Get started with Foqal and set up your Google Sheets integration in minutes.
Clear all values from a single A1 range on a Google Sheets spreadsheet (formatting is preserved).
Create a new page (tab) on an existing Google Sheets spreadsheet.
Create a brand new Google Sheets spreadsheet.
Delete a page (tab) from an existing Google Sheets spreadsheet.
Delete a Google Sheets spreadsheet. The spreadsheet is moved to the Drive trash.
Find and replace text across an entire spreadsheet or within a single page.
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 every page (sheet/tab) on a Google Sheets spreadsheet along with its numeric sheetId, title, position, hidden flag, and grid dimensions.
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 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.
Rename a page (tab) on an existing Google Sheets spreadsheet.
Rename an existing Google Sheets spreadsheet.
Write a 2D block of values into a single A1 range on a Google Sheets spreadsheet.
Write a single value into a specific cell on a Google Sheets page.
