Google Data Studio is an application for creating data dashboards. It uses connectors to pull data from outside sources and visualizations (also referred to as “charts” in the UI) to display the data. Developers can create custom connectors to bring in data from sources not supported by the default connectors and custom visualizations to visualize data in ways not supported by the default visualizations.
Reference
Usage
Custom Connectors and Data Sources
- adding fields on a data source built from a Design Media custom connector
- using a custom connector as a user who has never used the custom connector before
- setting script properties on a custom connector
- setting a custom connector to run in the V8 runtime when developing locally
Local Development
- changing a local connector project’s associated remote connector
- hooking the CLI into an existing community connector
- setting a custom connector to run in the V8 runtime when developing locally
- change users- If you previously logged in as a Google user to use the custom connector CLI and need to switch to a different Google user, this gives instructions for doing that
Problems
Custom Connectors
Reference
Limitations
These are the current limitations (as of 2021-07-26) limitations for Google Apps Script which is the service that runs Data Studio community connector scripts. I have bolded features whose limitations I have run up against.
| Feature | Consumer (e.g., gmail.com) and G Suite free edition (legacy) | Google Workspace accounts |
|---|---|---|
| Script runtime | 6 min / execution | 6 min / execution |
| Custom function runtime | 30 sec / execution | 30 sec / execution |
| Simultaneous executions | 30 | 30 |
| Email attachments | 250 / msg | 250 / msg |
| Email body size | 200 KB / msg | 400 KB / msg |
| Email recipients per message | 50 / msg | 50 / msg |
| Email total attachments size | 25 MB / msg | 25 MB / msg |
| Properties value size | 9 KB / val | 9 KB / val |
| Properties total storage | 500 KB / property store | 500 KB / property store |
| Triggers | 20 / user / script | 20 / user / script |
| URL Fetch response size | 50 MB / call | 50 MB / call |
| URL Fetch headers | 100 / call | 100 / call |
| URL Fetch header size | 8 KB / call | 8 KB / call |
| URL Fetch POST size | 50 MB / call | 50 MB / call |
| URL Fetch URL length | 2 KB / call | 2 KB / call |
Source: Google Apps Script quotes and limitations