How to connect a private project to Google Sheets

Epicollect5 · 7 November 2023 13:44

From the User Guide →

You can follow the instructions here →

They provide a full example with precompiled scripts.

From the above link, this video explains how to connect a private Epicollect5 project to Google Sheets
→

The code required can be found here →

github.com

EnAccess/Survey-Toolkit/blob/main/Epicollect_5-Sheets_Integration.gs

var ui = SpreadsheetApp.getUi()

function getToken(client_id, client_secret) {
  
  var token = null;
  
  var options = {
    'method' : 'post',
    'contentType': 'application/json',
    'payload' : JSON.stringify({
      "grant_type": "client_credentials",
      "client_id": client_id	 ,
      "client_secret": client_secret
    })
  };
  
  try {
    token = UrlFetchApp.fetch('https://five.epicollect.net/api/oauth/token', options);  
  } catch(e) {}

This file has been truncated. show original