<aside> ✅ Link to plugin page: https://zeroqode.com/plugin/google-sheets---charts-service-1533643947345x977372778296246300

</aside>

Demo to preview the plugin:

<aside> ✅ Live Demo: https://zeroqode-demo-16.bubbleapps.io/google_sheets_charts_service

</aside>

<aside> ✅ Bubble Editor: https://bubble.io/page?version=live&name=google_sheets_charts_service&id=zeroqode-demo-16&tab=Design

</aside>

Introduction

Empower your applications with the ability to seamlessly interact with Google Sheets using a service account. With over 35 actions and counting, this plugin offers extensive functionality to import, export, and format Sheets data, control conditional formatting, build and edit embedded charts, configure data validation, create and update named and protected ranges, manipulate pivot tables, and more.

This plugin provides developers with a powerful toolkit to integrate Google Sheets seamlessly into their applications, enabling efficient data management, visualization, and analysis.

Prerequisites

You must have a Google Service Account, if you do not then just follow our steps.

A service account is a special type of Google account that belongs to an application or a virtual machine (VM), rather than an individual user. It's used for authenticating and accessing Google Cloud Platform (GCP) services programmatically, typically in a server-to-server or application-to-service communication scenario.

banner-need-help-last.webp

Getting Setup

Register a Google Service Account with JWT (link) and obtain keys

Plugin API Calls

Create Spreadsheet (Action Type Call)

<aside> 💡 To have access from Google Sheets to the created Spreadsheet ,you have to first give access to the document through “Allow Spreadsheet Access” api calls, choose the one that better suits your needs (anyone, user). For opening the spreadsheet link you can use: https://docs.google.com/spreadsheets/d/ Paste here the spreadsheet id/edit#gid=0

</aside>

Get Spreadsheet (Action Type Call)

Get Spreadsheet (Data Type Call)