Run Requests Outside the Sidebar

For convenience, you may want to run requests directly from your sheet, without opening up the main sidebar. There are 3 ways to do this:

  1. From Google Sheets, click Add-ons > API Connector > Refresh All Now. This will run all the requests in your sheet without opening the sidebar.
    run-without-sidebar-img1
  2. Trigger the Refresh All Now function with a button as follows:
    • Insert a button anywhere you want in your sheet (Insert > Drawing > Shape)
    • Right-click your button and you’ll see a 3 dot menu appear on the side
    • From that menu, choose Assign script
      run-without-sidebar-img2
    • Enter ‘refreshRequests’ (without the quotation marks) into the text entry field
    • Now when you click your button, it will launch the Refresh All Now function.
  3. Use the ImportAPI custom function to run specific requests from cells in your sheet.

2 thoughts on “Run Requests Outside the Sidebar”

  1. I’m getting an error on the button. It says:

    You do not have access to perform that action. Please ask the owner of this item to grant access to you.

    Is there something else I need to do to get this to work?

    Reply
    • Hey John, I’m not sure why you’re getting this error, you shouldn’t need to do anything else beyond what’s written. It seems to be a permissions issue on Google’s side. Are you logged into multiple Google accounts by any chance?

      Reply

Leave a Comment