Decisions and google spreadsheets Integration
Comments
-
At this time, we do not. However there are a couple of alternative processes you can setup to give you a similar functionality:
[b]Method 1.[/b] You can directly download the Google Sheets as an xlsx or csv file and send it to Decisions manually.
[b]
[/b]
[b]Method 2.[/b] Google Drive also includes a REST Api service that lets you export your file using the following REST API: https://docs.google.com/spreadsheets/d/[fileID]/export?format=xlsx&id=[fileID], but replace [fileID] with the sheets ID. (You can locate your documents ID in Google Drive by right clicking on the file and select Get Shareable Link. The last part of the link provided by Google Dreive is the file Id.). For more information on Google Drives APIs, please refer to this website: https://developers.google.com/drive/api/v3/reference/files/exportIf the need for this is to load Google Sheet data into Decisions, using Method 1 and using this file in Decisions will be easier to set up and use.
However, if this needs to be part of an automated process, then you may need to look into ways to automate that download operation, likely with Method 2.
Howdy, Stranger!
Categories
- 4.3K All Categories
- 74 General
- 11 Training
- 206 Installation / Setup
- 1.1K Flows
- 110 Rules
- 268 Administration
- 212 Portal
- 496 General Q & A
- 709 Forms
- 343 Reports
- 3 Designer Extensions
- 48 Example Flows
- 57 CSS Examples
- 1 Diagram Tile
- 7 Javascript Controls
- 184 Pages
- 5 Process Mining
- New Features
- 186 Datastructures
- 70 Repository
- 229 Integrations
- 28 Multi-Tenant
- 27 SDK
- 81 Modules
- 58 Settings
- 25 Active Directory
- 12 Version 7
- 35 Version 8
- 143 Lunch And Learn Questions