Templates Plugins Courses

Error When Testing Google Sheets API with Bubble.io


We installed the Google sheets API & think we followed the instructions for set-up from the links https://docs.zeroqode.com/plugins/google-sheets-+-offline-plugin#demo-to-preview-the-settings - https://bubble.io/page?type=page&name=index&id=googlesheetsplugindemo&tab=tabs-1

However, when we try to run a simple action to read sheet values and input into repeating group, the content does not display.

Error The service Google Sheets + Offline - Read Sheet Values (Action) just returned an error (HTTP 400). Please contact the plugin author directly for feedback. Raw error:

Invalid query parameter value for grid_id.

Hi there @gage.smith!

Thank you for your feedback on our products. We have investigated this issue and it seems that plugin is working properly on our side. In order to solve this problem, please try to make sure that the plugin has been configured properly, again.
In case you experience the same or other types of issues, I would like to ask you to send screenshots of your plugin and elements configurations.

Note: when you type the Sheet Name, make sure it is the name of the sheet and not the name of the actual file. It should be something like “Sheet1” by default.

Hope it is helpful!

Best regards,

In the demo on this page for “(path) spreadsheetid” it looks like you have inserted dynamic data however we do not currently have the option to insert “input” or “'s value” in the field to apply to the sheetid.

For the “(path) range” we cannot insert the dynamic data options either.

When we debug it both the ID attribute and data source are listed as “empty”

Hi @gage.smith,

Thank you for your feedback. Unfortunately, this issue is not reproducing on our side. We tested it your way and it seems to be working properly, it is possible to insert the dynamic data. Just click on the field and the “Insert dynamic data” option should appear and you are able to choose “Input”.
In case it doesn’t work, I would like to ask you to add our [email protected] account to your collaborators list in Settings -> Collaboration of your application. Also, tell us the name of your app and page name where you are developing it, so we could test and try solve the problem inside your app.

Note: Don’t pay attention to the alert message regarding Professional Plan, as we are an agency and you can easily add as to your collaborators list.

Best regards,

Hi @gage.smith,

Thanks for sharing your app. We have checked it and understood the issues. The reason you cannot insert “Input” values to apply them for the (path) spreadsheetId and (path) range is because there are no Input elements on the page to be taken from. There is also another issue on why data cannot be displayed, that is in the workflow logic. Currently, it is trying to display data when the page is loaded without actually being logged in into your Google account, so it doesn’t see it. It is impossible to retrieve any data without being logged in.

To solve this is relatively easy. To make things simple, I would highly suggest you check the demo app here https://googlesheetsplugindemo.bubbleapps.io/ and the editor here https://bubble.io/page?type=page&name=index&id=googlesheetsplugindemo&tab=tabs-1 and please see how it is built and try replicate all of the steps the exact way, in order to understand the workflow and make things work inside your app.

Best regards,