At our school we just got our farm.bot working. We, a team of 10 students and two teachers, have big plans and are very excited
We would like to use Google Looker Studio to make our bot’s data more accessible to students outside our team - to provide research opportunities and to build a bit of a social media presence. To this end, we would like to learn how to write sensor and other data to google sheets and how to copy photos to our own Google Drive.
We are new to the farm.bot, willing to get our hand dirty doing some coding and figuring out, but could use a pointer as to where to start with figuring this out. Does what we are trying to do make sense? Has it been done before?
Hello @farmbotatunishanoi!!! Welcome!
I love to see that they are moving forward with this project in a school!
I wanted to welcome you and accompany you with good energy as you continue forward.
Regarding your question, I cannot answer you because I do not have the necessary knowledge. I hope that someone else in the forum can give you some guidance on where to move forward in the development that allows you to export the data from the sensors.
I can only think of giving them the idea of setting up a self-hosted instance (on their own server) to be able to have the data available, directly access the database and have more flexibility. But I understand that this path is a little more complicated (a little…) I personally was able to replicate the services environment (servers) locally to do my preliminary tests. I achieved it with little technical knowledge (researching and reading).
Good luck and I hope to continue seeing the progress of your project! A hug
Never lose enthusiasm, desire to learn and transform this world into a more harmonious and beautiful place!
I would recommend starting with our Lua developer documentation if you want to take the approach of uploading data to a 3rd party server directly from the FarmBot (assuming the other server uses API keys to authenticate as opposed to some other authentication method such as OAuth).
The other approach would be to grab data from the FarmBot REST API (documentation) and then move it to Google’s servers, process it locally, etc.
And, while a bit more involved, @luciano.dlf’s solution of running your own FarmBot server is also totally valid, though doesn’t necessarily improve your access to your own data compared with just using the my.farm.bot server.
Keep us informed of your progress. I’m sure others would be interested in methods you develop such as storing images in Google Drive.
Sounds like a neat project!