Hello,
I am almost there - but something is still going wrong. Who is able to have a look at it?
Thank you in advance
Jiska
@vladlarin has an API that should accomplish what you need.
1 Like
Thanks @josh10!
Yes, we got a few that may be helpful!
What exactly you are trying to accomplish, @Josss?
Please share the link @vladlarin
We got a few right here you are welcome to check and test, depending on what exactly is your scenario.
They’re different, so I cannot recommend a single one without knowing the use case, sorry.
Hi all,
Thanks for the responses. I already bought the API Google Sheets + Offline. I made my Google sheet open so I don’t need to log in. However I have the idea that I still need to install the API Connector. Is that correct?
Do you have a good example which I can follow? Or is there somebody who can support?
Thanks in advance
Jiska
And do you still need to Authorize Google every time you log in? Is there a way to escape from that?
Many thanks in advance!
@vladlarin could you please support?
Thanks in advance!
1 Like
Sorry, I missed this 
Will ask my team to look into that ASAP.
Thank you in advance @vladlarin and team.
If you want to read and write cells in Google Sheet [open], do you only need the Plugin API Google Sheets + Offline or do you also need to install the API Connector?
Without the API connector installed - it does not work now, the information I would to show (by reading) and the information I want to send (by writing) does not work. I get the following error:
The service Google Sheets + Offline - Append Rows To a Sheet just returned an error (HTTP 401). Please contact the plugin author directly for feedback. Raw error:
{
- "error": {*
- "code": 401,*
- "message": "Request is missing required authentication credential. Expected OAuth 2 access token, login cookie or other valid authentication credential. See https://developers.google.com/identity/sign-in/web/devconsole-project.",*
- "status": "UNAUTHENTICATED"*
- }*
}
I would expect that it must work only having the API Google Sheets + Offline, but apparently I have to authenticize.
In case the API Connector is needed in addition to the API Google Sheets + Offline, do you have any examples or proper explanation how to set it up for success?
Thank you in advance!
Jossss
Hi @Josss,
Thanks for reaching out. In order to make this plugin work properly, it is required to be authenticated with your Google account, first. Please check the plugin’s documentation here https://docs.zeroqode.com/plugins/google-sheets-+-offline-plugin that will walk you through the whole configuration process step by step, including all necessary installations. There is no need in configuring the API Connector specifically for this plugin.
Best regards,
Zeroqode Team
Hi,
This google sheets plugin misses the mark in a couple of places.
-It gets flagged as “unsafe” when connecting to Google. Google suggests not using because safety certificates are up to date
-When connected to Google and a specific spreadsheet " eg. A spreadsheet has an ID like so,_ 1PciD2dkT3IJTuIJ0484XjdoalxBfSXStkL3sFpIYj4QT" connects but then in step one of the demo test kicks back a 400 error.
My objective: I have to build a calculator app that my formulas are implemented within the Google sheet. I’d like through app (ios) to collect a date > drop it into my Google Sheets> then pull out the individual values and propagate them back into the ios app. It’s (1) value in and (5) back out.
So far I cannot even tell if this plugin has the capability to accomplish this using Google Sheets because of all of the errors. It needs to be reviewed for security and accuracy.
Any advice welcome with my project. Other Google sheets plugin ideas welcome.
Hello, @elizabethhannan. Thanks for reaching out.
As long as our demo pages are test apps, and are used for the demonstration purposes, they don’t need to be verified with Google:
The demo page will throw an error if you’ve set invalid or empty data to input fields. If you indicate correct data, you will be able to see the result on this page:
https://www.loom.com/share/4fb92ced3991462bae4159f219b11f6e
Would you kindly examine the plugin documentation and editor (workflow setup, etc) pages for a better understanding of the plugin capabilities:
https://docs.zeroqode.com/plugins/google-sheets-+-offline-plugin
I presume this plugin can handle the functionality you want to implement in your app. You will need to collect the data (into the app database or via the API Call )> Update the sheet with the data you’ve collected > display the resulted data into the group/repeating group.
Please also note that this suggestion may need testing within the environment of your app (data you want to collect, data processing with the plugin, etc).
Also, you can subscribe to this plugin to test it out in your app. You will pay only for the days you were using the plugin.
Regards,
Zeroqode Team