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.2K All Categories
- 68 General
- 11 Training
- 203 Installation / Setup
- 1.1K Flows
- 108 Rules
- 264 Administration
- 212 Portal
- 494 General Q & A
- 702 Forms
- 334 Reports
- 3 Designer Extensions
- 47 Example Flows
- 53 CSS Examples
- 1 Diagram Tile
- 7 Javascript Controls
- 180 Pages
- 5 Process Mining
- New Features
- 181 Datastructures
- 69 Repository
- 222 Integrations
- 28 Multi-Tenant
- 27 SDK
- 81 Modules
- 57 Settings
- 25 Active Directory
- 12 Version 7
- 35 Version 8
- 106 Lunch And Learn Questions