I am having a hard time getting my trigger hook to work in side glide. My Pabbly hook is working perfectly. I am using google sheets. I am able to use the app script url in a web address and it writes to my sheet every time.
When I trigger my button in app, it never writes to the sheet, or occasionally it gets an error 405. i think it has something to do with my trigger url, but I’m unsure on how to correct it.
Might not be the same thing, but please see the final solution in this thread to see if it works for you.
Can you explain what your automation does that Glide can’t do?
Hi Thinh,
Thanks for the reply. I will have a look. Thanks. unfortunately, I’m not on the business plan and don’t have access to ‘API CALL’ just on the maker currently.
I am trying to pull info from my google sheet to my glide table with a trigger hook to pull in current information. This is just current weather info weather info. It is also sending location out from glide sheets to identify local weather where the user is.
I have been getting everything from 403, 404, 405, and 305 errors.
I have a feeling that it is something in the trigger url. Depending on how I write it, it triggers different errors.
So you have a function in your Google Sheets that returns weather info, and you’re retrieving that back into your Glide table?
Is there a reason you don’t just connect that sheet to Glide?
I’m brand new to Glide. I’m not sure what you mean.
Thanks Darren. Unfortunately, this doesn’t address my issue. I already have it connected, they are just not talking to each other appropriately.
In what sense?
Can you elaborate?
What you are trying to do should not be necessary, unless you’re doing calculations in the Google Sheet, and waiting for the results to sync back to Glide. And if that’s the case, my advice would be don’t do that. Do it in Glide instead.
Hi Darren,
I am making a weather portion to my app. I am using my API key in the code in my Apps script. What I need it to do is send the user’s location to the google spreadsheet from glide sheets, to trigger the api to to give correct information and give that back to Glide sheets to show current information for the facing user.
Okay, understood.
So I don’t think connecting the Google Sheet to your App is the solution, as you’ll still have sync delays to deal with.
I think you probably have two options:
The second option would be easier, I think. I’m pretty sure there are lots of free weather API’s out there. You could do it with your current API, but you would be risking exposing your API key.
Open weather app is the one that I am using.
Hi Darren,
This is using API Call correct? I don’t have access as I am only on the Maker subscription.
You could do it with JavaScript, or potentially even with the Get Webpage Source column.
Hi Darren,
The issue I am having, is that the free api’s don’t have the info I need. Specifically barometric pressure. Thoughts?
Are you familiar with make.com?
I think that could be a good option for your use case. You could do something like:
I believe the above should be possible on the Maker plan.
Out of curiosity, what do you use barometric pressure for? (I have a background in meteorology, I spent 18 years working with the Australian Bureau of Meteorology).
Hi Darren,
It is important for understanding some patient symptoms for brain issues post surgery.
