B4R Question reading/writing to google shared doc from ESP

giggetto71

Active Member
Licensed User
Longtime User
Hi guys,
I am looking for a way to access (read/write) a shared sheet on google drive from an ESP connected to the network.
the sheet I have created is not restricted: I have chosen the option "Anyone with link". any chance?
thanks!
pierluigi
 

hatzisn

Well-Known Member
Licensed User
Longtime User
With IFTTT and you can write to a Google Sheet.
 
Last edited:
Upvote 0

hatzisn

Well-Known Member
Licensed User
Longtime User
Have a look at this example:

 
Upvote 0

hatzisn

Well-Known Member
Licensed User
Longtime User
Why would you need this? It is just a post request using rHttpUtils2 library.
 
Upvote 0

giggetto71

Active Member
Licensed User
Longtime User
Ok. Got it thanks. I guess i would then need an example to go through. Can you suggest something i could start from? Thank you very very much!!
 
Upvote 0

hatzisn

Well-Known Member
Licensed User
Longtime User
Pause the video above in the correct moments and copy the link to the server (it is server + the following) and also the JSON string to post. And in bocca al lupo.
 
Upvote 0

giggetto71

Active Member
Licensed User
Longtime User
@hatzisn , thank you very very very much..using Webhooks service in IFTTT I was able to create an event triggering to write on a google sheet by posting to the address as: (of course the key is not 12345678...)


and also with a B4J app:
B4X:
Dim httptask As HttpJob
    httptask.Initialize("httptask",Me)
    httptask.PostString("https://maker.ifttt.com/trigger/MyEvent/with/key/12345678?value1=123&value2=456",Null)
    
    Wait For (httptask) JobDone(Job As HttpJob)
    
    If httptask.Success Then
.......

did not try yet from B4R but I expect should work the same, correct?
thanks again
 
Upvote 0

hatzisn

Well-Known Member
Licensed User
Longtime User
Glad you did it. It looks like I created an example for nothing now that I took a break for the noon. I will post it anyway in case someone needs it.

Edit: Now that I read your message till the end it seems my effort was not in vain.
 

Attachments

  • IFTTTToGoogleSheet.zip
    1.4 KB · Views: 83
Last edited:
Upvote 0
Top