Jop asked 5 years ago
Hi Sara or Rui,
As clear as your guidance in your project to use the IFTTT-platform so unclear is this interface these people behind IFTTT have created.
With your info I could create an IFTTT-applet to set my sensor readings in a Google Sheet. But it costed me a lot of time to find out that it is NOT possible with IFTTT to put more as 3 values in my sheet. This info is not communicated by the IFTTT-people – also remarks as “you have to upgrade to a PRO version or something like that” is n’t given. Bad communication. Also support from IFTTT is missing.
Now I try to create another IFTTT-applet for an second Google Sheet, but even with your clear info, I don’t get this done. I’m missing the screens for the unique key. The testbutton on the IFTTT-platform suggests performing a test action but I don’t see my new Google Sheet appearing in my Google Drive.
Could it be that here another missing information from IFTTT side is due to my bad experiences with IFTTT?
Maybe free IFTTT-accounts are very limited, but they don’t have the guts to tell us. To find all limitations with trial-and-error is not as should be.
I hope I am wrong
With regards,
Jop
Jop answered 5 years ago
In follow-up of my last post I accidentally found that I can use the same key, but have to change the trigger to the event I filled in for the new Applet I created on the IFTTT-platform.
For example:
const char* resource = “/trigger/bme_readings/with/key/bn6oHGFT67DF89CFfPfjAk”;
const char* resource = “/trigger/Jop_event/with/key/bn6oHGFT67DF89CFfPfjAk”;
but still the test-button on IFTTT doesn’t do anything.
Kind greetings,
Jop
Jop answered 5 years ago
I’ve got done to contact support of the IFTTT platform.
The limit of max. 3 values to upload in a Google Sheet (so max. 3 columns) seems to be set by Google.
Here the answer I got from IFTTT-support:
=========
Hi Jop, Audrey here from Platform Support.
What you’re describing are rate limits set by the Webhooks’ service, in this case, Google Sheet and not by IFTTT.
========
I hope this will be helpful for you all.
Kind regards,
Jop
Sara Santos Staff answered 5 years ago
Hi Jop.
I’m sorry for those issues.
Yes, you can only publish three columns with IFTTT with the “free” version. If you want to publish more data, you can concatenate different types of data on the same column (it is not ideal, I know).
Recently, we’ve create a project in which you can publish your sensor data to your own database. So, you can publish as much columns as you want: https://randomnerdtutorials.com/esp32-esp8266-mysql-database-php/
I’m sorry for the delay in my response.
If you need further help, you just need to post a new question.
Regards,
Sara