Vendor integration - Google Sheets (API key)

Fabio Matera
Fabio Matera
  • Updated

How to get the Google Sheets API key

You need a personal Google account, not a Google Suite account issued by your school or business.

Warning: depending on your account settings, your screen instructions may vary from those listed below.

  1. Go to the Google Developers Console at https://console.developers.google.com/ and log in to your Google account. Google may ask you to identify your country and agree to its terms of service.

  2. Click on Select a Project on the opening screen and on New project afterwards.

Capture1.PNG
  1. In the next screen, give your new project a meaningful short name to remind you of its purpose, such as google-jetti. You do not need to create an organization or parent folder. Then click Create.
Capture2.PNG
  1. In the next screen, click on Google Cloud Platform at the top of the page, and on Go to APIs overview afterwards. 
Capture3.png

 

  1. Click on + ENABLE APIS AND SERVICES and search for Google Sheets in search bar that appears. 
Capture4.PNG

 

  1. Once clicked on Google Sheets API, select the Enable button to turn on the Google Sheets API for your project.
Capture5.PNG
  1. In the left sidebar menu, click Credentials, then click on To view all credentials visit Credentials in APIs and services, then + CREATE CREDENTIALS and select API key.
Capture6.PNG
  1. In the next screen, the console will generate your API key. Copy it, then press Restrict key.
Copy your API key and press Restrict key.
  1. In the new window, under API restrictions, choose the Restrict key radio button. In the dropdown that appears, choose Google Sheets API, then click Save.Capture7.PNG
You can now insert your Google Sheets API key in Jetti going on Integrations, click then on Google Sheets that you find at the bottom of the page. You can insert here your Google drive api key and click Save

Capture8.PNG

 

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.