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

    • Related Articles

    • How to get BSE Star MF API for integration in Finnsys ?

      MFD Model (For ARN Holders/IFAs) SEBI vide its circular CIR /MRD/DSA/32/2013 dated 4th October, 2013 has allowed Mutual Fund Distributors to use re-cognized stock exchanges' infrastructure to purchase and redeem mutual fund units directly from Mutual ...

    • How to create and use Google reCAPTCHA ?

      Prevent Bots from spamming your query or signing up forms with fake emails. Are you getting hit with notifications of spammy accounts being created on your website? Did you know that malicious computer programs called “spambots” search the internet ...

    • How to acquire NSE NMF API UN & PW for integration in Finnsys ?

      Before proceeding to activate your NSE API services, make sure you are registered with NSE API in the first place and you have the NSE username - MFSXXXXX with you. If not please click here to register with NSE. What is API? API acts as a connector ...

    • How to acquire BSE API UN & PW for integration in Finnsys ?

      If you are registered with BSE Star MF and are using their portal www.bsestarmf.in to onboard clients and place their order through BSE then that's good. You are now 1 step away towardings integrating BSE STAR services on your website and Mobile App. ...

    • How to Create Google Developer Account for uploading your Android App ?

      This article describes how to create and set up your Play Console developer account Step 1: Sign up for a Play Console developer account with your Google A/c which uses your business E Mail ID like...your name @yourdomain.com, support@yourdomain.com ...