>>> Conrad Connect Webinar >>> "Wie auch Sie von IoT profitieren" am 7. April, 2020, 15 Uhr
Creating multiple Google sheets
Razorvla
Member Posts: 2 ✭
I created a sketch to get data from multiple Mobile Line sensors (température, h2o, Rain) which writes the data every 7 mins in a Google sheet.
It worked nicely for a month but now It creates a new sheet randomly named exactly as the one i wrote in the sketch.
Why does It makes It ?
Thank you
Answers
Hi @Razorvla, do you mean these sensors?
Did you ever solve this? I have always had the same issue using the mobile alerts sensors. This month it created 20 ( yes 20!!) new documents in one day. In the past it has been about 1 a month at random.
Hi @jonlomas, can you please describe your problem in more detail? Does writing multiple data sources to one google sheet itself work? Can you please publish the project and post a link to it?
It is exactly the sensors you showed
Hi @Razorvla, thanks, the support team will be looking at it on Tuesday!
PS: They've set up a test project so as to monitor behavior over time.
Sorry for posting on a long dead thread, but i can't find info on this anywhere else.
I have recently been having this exact issue, did you find any cause?
Hi @UonMMT, sure, we're here to help. How exactely may I help you?
I've i have a setup just like described above, technoline temperature sensors, using conrad connect to record datasets in google sheets. Randomly, a new Spreadsheet is created in google sheets. i have many sheets with just 1 time slot recorded, others are days before a new one is made.
Hi @UonMMT, thanks for the update. I will ask the support team to test exactely this scenario. What sensors parameters do you use exactely (e.g. temperatur indoor vs. outdoor) and which hardware is employed?
Hi @UonMMT, may we kindly ask for a screenshot of the entire project?
Hi @UonMMT, please also indicate the type and model of your sensor.
Here's the image of the project, and the sensors are (Technoline Mobile Alerts MA-10001-UKSET)
Hi @UonMMT, in order to write multiple sensor readings into one Google sheet, please refer to the tutorial here.
Hi Christian,
That isn't my issue, this is how my google sheets appear
Usually, each sheet looks like this:
But sometimes, they put this much data in, and then create a new SS with the same name.
Hi @UonMMT, thanks, but I still need to understand your problem better: 1) CC creates multiple Google Sheet files (were only one was supposed to be created, and 2) some sheets only contain one row of data (were multiples rows were supposed to be created), right?