search

rcastillejo / hello-world

Hello world react application for finance PoC
0 stars 0 forks source link

Investigate the effort to connect the spreadsheet #15

Open rcastillejo opened 1 year ago

rcastillejo commented 1 year ago
  1. Check the configuration for application to connect the following spreadhseet
  2. Check the configuration for google to allow permission to app
  3. Edit the content of spreadsheet as same from PoC
  4. Use console log to check the connection
rcastillejo commented 1 year ago

Related the configuration for google to allow permissions

Enable Google Sheets API: To interact with the Google Sheets API, we need to enable it in the Google Cloud Platform (GCP) console. Follow the steps below:

  1. Go to the GCP console: https://console.cloud.google.com/

  2. Create a new project or use an existing one. -- https://console.cloud.google.com/welcome?hl=es&project=myperfonalfinanceapp

  3. Enable the Google Sheets API for your project. -- https://console.cloud.google.com/apis/library/sheets.googleapis.com?hl=es&project=myperfonalfinanceapp

Image

  1. Create credentials (OAuth client ID) to access the API. (Pending)
  2. Download the credentials as a JSON file, which we'll use later in our code.