### Author:  [@Darren\_Alderman](https://community.glideapps.com/u/Darren_Alderman)
#### Post date: [September 29, 2021, 9:31pm UTC](https://community.glideapps.com/t/solved-i-want-to-create-a-webhook-that-adds-a-row-to-a-glide-table-for-fun/32477/1 "2021-09-29T21:31:37Z")
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:
> [@robot Importing data to Glide by use of robot (RPA)](https://community.glideapps.com/t/importing-data-to-glide-by-use-of-robot-rpa/29008):
>
> Challenge 1 In this moment of time it is not possible to import data (or paste chunks of data) into Glide. @Manu.n has shown a way to import a row at a time from Google sheets to Glide tables which is quite handy if you have not to much data to import. But if you have hundreds or thousands of rows this approach is not the way to go.
>
> > **Manu.n's approach - great for a smaller number of rows**
> >
> > \
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [September 29, 2021, 9:48pm UTC](https://community.glideapps.com/t/solved-i-want-to-create-a-webhook-that-adds-a-row-to-a-glide-table-for-fun/32477/2 "2021-09-29T21:48:33Z")
Interesting idea…very hacky, but might be possible? This is out of my realm of expertise.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [September 29, 2021, 9:57pm UTC](https://community.glideapps.com/t/solved-i-want-to-create-a-webhook-that-adds-a-row-to-a-glide-table-for-fun/32477/3 "2021-09-29T21:57:36Z")
That’s an interesting idea. I did try another way of mimicking the API call to add rows to a table the other day, but never succeeded.
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [September 29, 2021, 10:41pm UTC](https://community.glideapps.com/t/solved-i-want-to-create-a-webhook-that-adds-a-row-to-a-glide-table-for-fun/32477/4 "2021-09-29T22:41:15Z")
Hola… good point!
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.
This post created by @Zancoper time ago shows how to connect a Firebase database and put its data into a Google Sheet in an “easy way”:
[Import data from Firebase to Glide](https://community.glideapps.com/t/import-data-from-firebase-to-glide/26230)
,
Saludos!
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [September 30, 2021, 2:31am UTC](https://community.glideapps.com/t/solved-i-want-to-create-a-webhook-that-adds-a-row-to-a-glide-table-for-fun/32477/5 "2021-09-30T02:31:23Z")
My immediate thought is you could probably do this with a functional test automation tool. Something like [Selenium](https://www.selenium.dev/), for example.
---
### Author:  [@Dan\_San](https://community.glideapps.com/u/Dan_San)
#### Post date: [September 30, 2021, 3:00am UTC](https://community.glideapps.com/t/solved-i-want-to-create-a-webhook-that-adds-a-row-to-a-glide-table-for-fun/32477/6 "2021-09-30T03:00:22Z")
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
---
### Author:  [@Darren\_Alderman](https://community.glideapps.com/u/Darren_Alderman)
#### Post date: [September 30, 2021, 1:49pm UTC](https://community.glideapps.com/t/solved-i-want-to-create-a-webhook-that-adds-a-row-to-a-glide-table-for-fun/32477/7 "2021-09-30T13:49:55Z")
> [@gvalero](#):
>
> Anyone can access Firebase databases via API using a Key
Honorable suggestion, but not a route I want to pursue at the moment.
> [@Darren\_Murphy](#):
>
> Something like [Selenium](https://www.selenium.dev/)
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.
> **[No code browser automation | axiom.ai](https://axiom.ai/)**
>
> Build browser bots quickly, without code. Automate website actions and repetitive tasks using just your browser, on any website or web app.
> [@Dan\_San](#):
>
> UiPath its a very good RPA tool
Thanks for the suggestion! I’ll take a look at that too.
---
### Author:  [@Darren\_Alderman](https://community.glideapps.com/u/Darren_Alderman)
#### Post date: [December 2, 2021, 2:07pm UTC](https://community.glideapps.com/t/solved-i-want-to-create-a-webhook-that-adds-a-row-to-a-glide-table-for-fun/32477/8 "2021-12-02T14:07:16Z")
# I figured it out! 🎉 🎉 🎉
I have successfully created a _ **HACKY** _ workaround to **add a row to a Glide Table via a webhook.**
### Problem
The Glide Tables API is currently only available to Enterprise clients, so I had the idea for a workaround…
### Solution
Instead of
`API`👉`Glide Table`
… what if we could do …
`API` 👉`RPA tool that completes Glide form` 👉`Glide Table`
This is possible with [Axiom.ai](https://axiom.ai/?source=ita) and their new Zapier integration and it’s all no-code!
### Tutorial
See a demo (3:50) and a full tutorial (4:27) here…
[ ](https://www.youtube.com/watch?v=4AI_kjf6nSg)
_Note: This was indeed a fun project, but is not an official recommendation from me as a Glide Expert._
---
### Author:  [@kyleheney](https://community.glideapps.com/u/kyleheney)
#### Post date: [December 2, 2021, 2:29pm UTC](https://community.glideapps.com/t/solved-i-want-to-create-a-webhook-that-adds-a-row-to-a-glide-table-for-fun/32477/9 "2021-12-02T14:29:48Z")
This is really, really cool.
---
### Author:  [@Krivo](https://community.glideapps.com/u/Krivo)
#### Post date: [December 2, 2021, 4:15pm UTC](https://community.glideapps.com/t/solved-i-want-to-create-a-webhook-that-adds-a-row-to-a-glide-table-for-fun/32477/10 "2021-12-02T16:15:50Z")
@Darren_Alderman Very nice job, Darren!
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.
Thanks a lot for sharing!!
> [@robot Importing data to Glide by use of robot (RPA)](https://community.glideapps.com/t/importing-data-to-glide-by-use-of-robot-rpa/29008):
>
> Challenge 1 In this moment of time it is not possible to import data (or paste chunks of data) into Glide. @Manu.n has shown a way to import a row at a time from Google sheets to Glide tables which is quite handy if you have not to much data to import. But if you have hundreds or thousands of rows this approach is not the way to go.
>
> > **Manu.n's approach - great for a smaller number of rows**
> >
> > \
### Author:  [@Aymeric\_de\_Maussion](https://community.glideapps.com/u/Aymeric_de_Maussion)
#### Post date: [December 2, 2021, 5:09pm UTC](https://community.glideapps.com/t/solved-i-want-to-create-a-webhook-that-adds-a-row-to-a-glide-table-for-fun/32477/11 "2021-12-02T17:09:34Z")
What ! That’s amazing ! I’m going to try to auto duplicate an app when a client buy me an App !
---
### Author:  [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)
#### Post date: [December 2, 2021, 5:27pm UTC](https://community.glideapps.com/t/solved-i-want-to-create-a-webhook-that-adds-a-row-to-a-glide-table-for-fun/32477/12 "2021-12-02T17:27:39Z")
Thanks 😊 superb creativity…
---
### Author:  [@Darren\_Alderman](https://community.glideapps.com/u/Darren_Alderman)
#### Post date: [December 2, 2021, 6:42pm UTC](https://community.glideapps.com/t/solved-i-want-to-create-a-webhook-that-adds-a-row-to-a-glide-table-for-fun/32477/13 "2021-12-02T18:42:37Z")
Thanks all!
> [@Krivo](#):
>
> 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.
This was my first automation, so I am by no means an expert. But it looks like the selector is pretty flexible. You can use some text on the screen instead of the HTML or set your own custom selector.
---
### Author:  [@Yasin\_Hassanien](https://community.glideapps.com/u/Yasin_Hassanien)
#### Post date: [December 2, 2021, 9:35pm UTC](https://community.glideapps.com/t/solved-i-want-to-create-a-webhook-that-adds-a-row-to-a-glide-table-for-fun/32477/14 "2021-12-02T21:35:12Z")
Does that work with private signin email apps or only public apps?
---
### Author:  [@Darren\_Alderman](https://community.glideapps.com/u/Darren_Alderman)
#### Post date: [December 2, 2021, 10:10pm UTC](https://community.glideapps.com/t/solved-i-want-to-create-a-webhook-that-adds-a-row-to-a-glide-table-for-fun/32477/15 "2021-12-02T22:10:28Z")
> [@Yasin\_Hassanien](#):
>
> Does that work with private signin email apps or only public apps?
Authentication is irrelevant. If you watch my video, you’ll see the solution uses browser bots. You can program a browser bot to do most of anything (like enter in authentication details).
With that said, since Glide uses pin authentication, private signin would be more difficult since you’d have to get a pin from an email after entering in a user email.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [December 2, 2021, 11:48pm UTC](https://community.glideapps.com/t/solved-i-want-to-create-a-webhook-that-adds-a-row-to-a-glide-table-for-fun/32477/16 "2021-12-02T23:48:24Z")
How about having a central public app where you have multiple tabs like this, make it completely public and run Axiom on different tabs for different tasks?
Just make sure that app’s URL isn’t leaked anywhere though.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [December 3, 2021, 1:55am UTC](https://community.glideapps.com/t/solved-i-want-to-create-a-webhook-that-adds-a-row-to-a-glide-table-for-fun/32477/17 "2021-12-03T01:55:57Z")
> [@ThinhDinh](#):
>
> Just make sure that app’s URL isn’t leaked anywhere though.
What could possibly go wrong? 🤔 🤣
---
### Author:  [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)
#### Post date: [December 3, 2021, 3:03am UTC](https://community.glideapps.com/t/solved-i-want-to-create-a-webhook-that-adds-a-row-to-a-glide-table-for-fun/32477/18 "2021-12-03T03:03:51Z")
This is really cool @Darren_Alderman! Thanks for sharing too!
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [December 3, 2021, 6:10am UTC](https://community.glideapps.com/t/solved-i-want-to-create-a-webhook-that-adds-a-row-to-a-glide-table-for-fun/32477/19 "2021-12-03T06:10:52Z")
Very hacky in all the right ways!!!
Not to far away from being able to say “Alexa, submit my Glide form for me.”
---
### Author:  [@Yasin\_Hassanien](https://community.glideapps.com/u/Yasin_Hassanien)
#### Post date: [December 3, 2021, 9:40am UTC](https://community.glideapps.com/t/solved-i-want-to-create-a-webhook-that-adds-a-row-to-a-glide-table-for-fun/32477/20 "2021-12-03T09:40:28Z")
I did this yesterday and it worked but I used pages which is better and has a tab link read to use
[Next page](https://community.glideapps.com/t/solved-i-want-to-create-a-webhook-that-adds-a-row-to-a-glide-table-for-fun/32477.md?page=2)