Available actions with ToolJet and Google Sheets integration
ToolJet's integration with Google Sheets supports various operations:
Read data from a sheet
This operation allows you to retrieve the table data from a spreadsheet in the form of a JSON object.
Append data to a sheet
Add additional rows to a table by using the append operation.
Update single row of a sheet
This operation allows you to update existing data in a sheet.
Delete row from a sheet
This operation allows you to delete a specific row from the sheet.
Why use ToolJet with Google Sheets
AI-powered app building
Build internal tools, workflows, and AI agents in hours using plain English. Go from idea to production with AI-generated apps, data models, and instant debugging.
Enterprise-grade security and compliance
Stay secure with SSO, RBAC, audit logs, encryption, and compliance standards like SOC2, ISO 27001, and GDPR. Deploy your way: cloud, on-prem, or hybrid.
Production-ready database and integrations
Skip setup hassles with instant PostgreSQL and pre-built integrations for AI, databases, storage, and APIs.
Components and environment management
Speed up development with 60+ pre-built components and manage releases across dev, test, and production environments.
Flexible development options
Use no-code visual builders, or dive into low-code, and switch seamlessly as your needs evolve. You have full control, and there is no lock-in.
JavaScript and Python
Write custom logic and data transformations using JavaScript or Python, flexible scripting built right in.