Google API calls get blocked

Comments

5 comments

  • Official comment
    Avatar
    Awesome Table

    Hello Thomas Ferell,

    I understand your concern but it is not possible to work around this. It is mandatory to use the apis.google.com & docs.google.com.

    Thank you for your understanding.

    Thomas

  • Avatar
    Jean-Rémi Delteil

    Hello Thomas Ferell,

    As Thomas mentioned justly, those calls must be made.
    They are not returning pre-generated HTML, but live data from the Google Spreadsheet. It is strange to want to block calls to Google servers when the data are hosted on a Google Spreadsheet !

    Best,

    Jean-Rémi

  • Avatar
    Thomas Ferrell

    Hi guys. Truly appreciate your quick responses you sent. I know the use case sounds a bit odd, but the Google Sheets are maintained by our internal team. We use it as kind of a database for the content. But we use Awesome Table published form for our clients (we don't care to expose to them the raw Google Sheets). You guys have any thoughts on work arounds? Like is it possible to proxy calls through our server or pre- generate the content beforehand and publish it statically so no run-time http calls are made on page load? Any thoughts would be helpful. I'm kinda feeling stuck on ideas.

  • Avatar
    Awesome Table

    Hello Thomas Ferell,

    Unfortunately, there is definitely no possibilities to work around this.

    Thank you for your understanding.

    Thomas

  • Avatar
    Jean-Rémi Delteil

    Hi Thomas Ferrell !

    If you are using the spreadsheet as the dataSource, there is no way not to make those calls. That is just not how Awesome Table is working.

    However as you mentioned using a proxy, have you studied the possibility to use a proxy with Awesome Table ?

    You can find an example here (https://support.awesome-table.com/hc/en-us/articles/115002883985).
    Please understand that instead of an AppsScript proxy you can make calls to which ever server you want. Just be aware that you will not be able to authenticate your user if you are not using an AppScript proxy.

Please sign in to leave a comment.