Reftek Sheet Integration Setup Steps - ashish-greycube/help GitHub Wiki

Google Console Steps For Authorization

  1. Go to this site and create Project
  1. Now go to Google Auth Platform and create Project.
  1. Create Credentials Using OAuth Client IDs:
  • Go to Client as shown in image and click on create client

After save copy client id and secret as this is required in further steps.

  1. Give Access Of App to any user (email id )
  1. Enable Google APIs
  • Search for API & Services.
  • Go to Enabled API & services.
  • Click on Enable and Enable Below 2 API
  1. Go to ERPNext and complete Google Settings
  1. Setup Google Drive in ERPNext

Google Service API Configuration For Formation

  1. Go to API & Services and Create Service Key

Skip Optional Details and Hit Save

  1. Click Manage Service Accounts.
  1. Click On Manage Keys
  1. Click on Add Key and Select New and Type JSON

After click on create it will download a json file.

  1. Open JSON file that will looks like below.
  1. Copy this JSON and Paste Into ERPNext Doctype "Google Spreadsheet Account"