Interact with Google Sheets using a service account. Import, export, and format data, manage embedded charts, configure data validation, and control spreadsheet permissions.
⚡ Main Functions•
Manage spreadsheets and sheets Create, retrieve, update, and delete spreadsheets and individual sheets programmatically.
•
Manipulate cell data Read, write, and clear specific cells, rows, or columns, and execute find and replace operations.
•
Configure charts and formatting Add or edit embedded charts, apply conditional formatting, and set up data validation rules.
⚡ Key Features🔐 Service account access Authenticate securely using a Google Service Account and JWT for server-to-server operations.
👥 Access control Grant, restrict, and manage user permissions and roles for specific documents.
⚙️ Workflow integration Automate extensive Google Sheets and Drive file management directly within your app.
DocumentationWe’ve created a detailed step-by-step guide for the Google Sheets & Charts (Service) Plugin. It includes a comprehensive overview of all features, practical use cases, and answers to frequently asked questions.
Supported API Calls✅ Get Spreadsheet Details - Retrieve detailed information about a specific spreadsheet, including its structure and metadata.
✅ Append Rows to a Sheet - Add new rows to an existing sheet in a Google Spreadsheet.
✅ Update Row - Modify the contents of an existing row in a sheet.
✅ Clear Range of Values - Clear the values within a specified range of cells in a sheet.
✅ Delete Rows - Remove one or more rows from a Google Sheet.
✅ Delete Columns - Remove one or more columns from a Google Sheet.
✅ Insert Empty Row - Insert a new empty row into a sheet at a specified position.
✅ Insert Empty Column - Insert a new empty column into a sheet at a specified position.
✅ Get User Profile - Retrieve profile information for the authenticated user, such as their name and email.
✅ Read Sheet Values (Action) - Read the values from a specified range in a sheet and return the data for further processing.
✅ Sheet Details XML - Retrieve the sheet's structure and details in XML format.
✅ Read Values (V4) - Fetch the values from a specified range in a sheet using the latest Google Sheets API (V4).
FAQ-
Is there any way to protect data in Google Sheets? Yes, the plugin allows you to create and manage protected ranges within your Google Sheets. This ensures that only authorized users can edit certain sections of your spreadsheet.
-
Can I apply conditional formatting to my Google Sheets through the plugin? Yes, you can apply conditional formatting to your Google Sheets using the plugin. This feature allows you to highlight cells based on specific conditions or values.
-
Is it possible to work with pivot tables in Google Sheets through the plugin? Yes, the plugin supports creating and manipulating pivot tables in Google Sheets. This feature is useful for analyzing and summarizing large datasets within your sheets.
-
Do I need an API key to use this plugin? Yes, you will need a Google API key to authenticate and interact with Google Sheets via the plugin.
Our Similar Plugins-
Google Sheets + Offline-
Google Charts-
Editable Data Table Like Excel Pro-
Google Sheets With Charts-
Air Chart Pro: 182 Premium Charts-
Google Sheet 2 Table
SupportIf you still have questions or unresolved issues, you can
contact us.
Risk-free TrialThe most risk-free way to try out this plugin is to subscribe to it. If you unsubscribe a few days later you will be charged on pro-rata basis, so for example if the plugin monthly price is $5 then you’d pay only 17¢ per day ($5/30 days)!
Built on Bubble
