connect google drive google sheets webhook

#CONNECT GOOGLE DRIVE GOOGLE SHEETS WEBHOOK CODE#
#CONNECT GOOGLE DRIVE GOOGLE SHEETS WEBHOOK FREE#

In most cases the row and column will be parameters, or based on parameters that you captured in the intent, might be with a case clause to do the translation, but this is up to you. To call this function, in a very simple example, you can do: You can see that the read is done accessing a Range, defined in this case as SheetName+Column+Row … but you could also access a bigger range.

#CONNECT GOOGLE DRIVE GOOGLE SHEETS WEBHOOK CODE#

Next step is to initialize the authentication and connect to Sheets:Īnd finally the code to perform the read, where we need to manage promises: The next section contains the fields of the API key that we have downloaded in the JSON file, and we only need 2 of them, the client_email and private_key, that you need to add to the code like this: In this snippet SheetDocument is the ID of the document that we found in its URL, and SheetName is the name of the Sheet, that defaults to Sheet1, but can be anything. Now you can build a new function that will perform the reading of a cell given a row and column: In the cloud function code (index.js) you also need to add the matching “require”: Edit your package.json and add the last line you can see here:

You need to add a new library to your dependencies, as we are going to use the Google APIs to access Sheets. We are done with the setup, now let’s go for the code: The next step is granting permissions to the service account, so it can access the spreadsheet: Look for it on the top search bar and enable it: You also need to enable the Sheets API in the GCP project. Selecting that account you can create a new key using the JSON format, and it will be downloaded to your local device: You can create a new Service Account or use the one that should be already there for “Dialogflow Integrations”: To create the API key you have to go to the GCP console in the project that you use to run the Dialogflow agent, looking for the APIs and then Credentials menu. In this example I’m going to use the API key option, which is the easiest way, and also the less secure, as you have to write down that key in the fulfillment code. To access this document you need to authorize the API … there are 2 methods that are documented here. The ID is the bunch of characters after the /d/ : The first step is to create or identify an existing spreadsheet using its URL.

If you use Google Sheets, there is an API that allows you to access data in spreadsheets, and we can access it from our agent’s fulfilment. For an education project I was asked to connect a Dialogflow virtual agent with a spreadsheet, so it contains information that we will provide to the users.

#CONNECT GOOGLE DRIVE GOOGLE SHEETS WEBHOOK FREE#

Hope this helps but please feel free to ask for any clarifications too, as required.Sometimes having an external database can be overwhelming in a small setup. The request parameters also describes the format of data that can be processed by the Web App. The available auth/permission settings are described here. The non-dev, prod-ready link would look something like this. You only have GET & POST requests (as of now) that can be handled by Apps Script's Web App and not the others that you've stated. In doing so, GAS provides you with it's own endpoint.Īdding this as a point of clarification where the endpoint/URL would not be that of a 3rd party, but that of GAS itself, which will need to be used in a 3rd party's application where they require you to provide an endpoint :) Google Apps Script (GAS) provides a format called as Web Apps where, you write a script to handle incoming requests and 'deploy' the Apps Script itself as a web app.

receive incoming data from an external (3rd party / non google) webhook.

Connect google drive google sheets webhook