How to get the API URL of your Google Sheets ?

How to get the API URL of your Google Sheets ?

Step-by-Step Setup GUIDE


  1. 1.Call our Support team or e mail at admin@armfintech.com to get the "Apps Script" for your Google sheets
  2. 2.Open your Google Sheet. Go to Extensions → Apps Script.
  3. 3.Delete any existing code in the editor. Open the downloaded file and copy-paste the entire script into the editor.
  4. 4.Click Save (floppy disk icon), then click Deploy → New Deployment.
  5. 5.Set Type = Web App. Under "Who has access" choose "Anyone". Click Deploy.
  6. 6.Google will ask you to Authorise — sign in with the Google account that owns the sheet.
  7. 7.Copy the Web App URL shown (looks like https://script.google.com/macros/s/…/exec).
  8. 8.Paste that URL in the Web App URL field above and click Save URL