I want to use Preston to display buttons from specific start-ups here, and then have it enter them into the spreadsheet via a Google Sheets API. I don’t have a problem if the whole thing works in regular Python, but IT doesnt Work in using Micro Python. Is there any problem? Does anyone have experience with this or have a script that could help me?
MicroPython feature/presto-wireless-2025 urequests VERBOSE error
I’m now trying to alternatively establish a connection via the post method and a URL: of the sheet. But that also seems problematic. MicroPython feature/presto-wireless-2025 urequests VERBOSE error
It must be possible somehow to get a file or data from a file from the board to a local system. An update via API works from the normal Python environment, but not from the board. I just need the option to read the data from, for example, the file DataID2.json from the board without my main script, which is writing the data, being aborted.
Now, back to what I’m actually planning to do. I have three buttons on the Presto (present, absent, home office). I want the status to be displayed in Sheets when a button is pressed.
Hard to see what is going wrong without code and error trace. Maybe you post your code that works (regular Python), and that does not work (MicroPython) including a full error-trace. GET and POST requests are no problem for MicroPython, so what you want to do seems possible (at this abstract level of course).
I would prefer an API interface. That works perfectly in Python, but there doesn’t seem to be a really functioning API library in Micropython. If that were the case, I would be able to have the script on the Presto send the status information directly to the Sheets table via the API. The POST method also causes problems, possibly because of https, I don’t know. I could now try sending the file with the data to a Pi5 and processing it there via the API. But that also causes problems, because the main script stops when accessing the data file via COM. So if there is a Micropython API, please let me know! Ultimately, I want to use around 50-100 Prestos for the Red Cross to display status information on a screen. If it works, there would be many good applications for it at the Red Cross. I’m open to any good ideas!
Ok, understood. When I enter “google sheets micropython” in my search-engine of choice, I have countless hits (libraries, tutorials). Have you tried any of those?
Try a Lot, also prompting Gemini. I remember a other Project with Pico Incy and Work now ON this solution with Sendung Email. It works and now I try to Work with that in Sheets using a Java Skript. Update: It is working well. Can send now Informations that Set by Press a Button in the Screen to Google Sheets by Email. Can use that also in Google Sites for showing all registrated Users. Great