- Login → Gmail Account → open( https://console.developers.google.com/ ).
- Click → “Select Project” → “New Project”.
- Fill up the Form → “Create” button.
- Search into Top search box → “Google Sheet API” and Enable API.
- Click → Create Credentials button → “OAuth Client ID”.
- Application Type → Select → Web Application.
- Authorized Javascript Origins → add → https://crm.pingtreesystems.com/.
- Authorized Redirect URL → add → https://crm.pingtreesystems.com/settings/getRefreshToken. → Save Button.
- Copy and Paste → Client ID and Client Secret → https://crm.pingtreesystems.com/settings – https://prnt.sc/26pyu7t.
- Click → “Save For Token” – https://prnt.sc/26pyvz6.
- Click → “Get Refresh Token” → Copy and Paste → https://prnt.sc/26pywu4.
