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.1K All Categories
- 61 General
- 11 Training
- 201 Installation / Setup
- 1.1K Flows
- 106 Rules
- 260 Administration
- 212 Portal
- 489 General Q & A
- 693 Forms
- 333 Reports
- 3 Designer Extensions
- 47 Example Flows
- 51 CSS Examples
- 1 Diagram Tile
- 7 Javascript Controls
- 178 Pages
- 5 Process Mining
- New Features
- 178 Datastructures
- 69 Repository
- 219 Integrations
- 28 Multi-Tenant
- 27 SDK
- 76 Modules
- 56 Settings
- 25 Active Directory
- 12 Version 7
- 35 Version 8
- 66 Lunch And Learn Questions