Currently we cannot add data to Glide tables outside. This is fine of course for now. I know it is in the backlog.
But I got curious on a walk the other day. Could we not call a webhook to some RPA tool that opens a headless browser that goes to a simple Glide app form and fills out the ‘Add’ form in Glide which creates a new row in the Glide table?
This is hacky of course, I just want to figure it out. I don’t intend on using it on a project.
@Krivo shared a way of doing something similar manually through the a command line tool:
But I was hoping to find a tool that would do the work for me. I’m having trouble finding a tool that would do this, so wanted to reach out to see if anyone knew of one. The tool just needs to be able to open a webpage and complete a form whenever a request is sent through a webhook. Bonus points for Zapier integration.
As far I know, the Glide’s backend is built on Firebase/Firestore so, the Glide Tables are Firebase tables indirectly. Anyone can access Firebase databases via API using a Key but we depend on Glide’s rules, restrictions and security reasons to get that API Key.
You can test with UiPath its a very good RPA tool, they have free version, the paid is very expensive.
We regularly use Selenium for writing user test cases, but it relies on having access to the CSS selectors to reference the correct components, I don’t think with GA we get can see the raw HTML, I think it is only viewport/embedded .js
For academic experimental purposes, can you not use experimental column to make an API call and save the data (the same you want to enter into a say FORM PEOPLE) and save that data into the experimental column. Then create a relation/lookup across to the sheet/table that has the target form and using SPLIT/JOIN/ then split the data into the necessary columns ? IF this can work, i’m not sure how you can get the same table to be updated via the API and the regular interface.
The other way is to use Google Sheets and use their API to write to Google Sheets which will sync with GA
Honorable suggestion, but not a route I want to pursue at the moment.
I left my corporate gig so I didn’t have to use Selenium anymore!
Right now the most promising solution I have found is Axiom. But I’m not sure I can trigger the task if I’m not on my local computer and clicking a button. I gonna play around with that today and continue my search.
Thanks for the suggestion! I’ll take a look at that too.
Any experience on how robust the robot is? Can it always find the correct input fields, buttons etc? Just wondering whether it uses class of e.g. input field - and what happens if it is a class which is non-static.
The user interface of the robot looks sweet - like it.
Your video is slick - great job. A lot nicer than the videos that I normally do
As you wrote in the first post I used another RPA tool which is closer to programming than Axiom - but I very much like your approach.