Selenium IDE with Airtable

External Apps
1

I did post the question in Airtable forum but I doubt anybody even seen it there.

I am looking to populate text based on the Airtable data and into a 3rd party web-form (e.g. commercial site) and I need to enter text + upload pictures. The challenges with regard to Selenium are multiple so here are a few:

  1. how to get Selenium access data in Airtable and always take the next line (next record) of data

  2. how to upload image to the 3rd party form (could be the form takes a URL or the file must be attached to the form).

  3. Write back to end result into airtable (e.g. success or fail) and also write to airtable the URL of the created finished page after submitting the form (e.g. taking that URL of the published page and save it to Airtable.

2

In an effort to keep our brand new forums clean & uncluttered, please try to create just one post per topic. I deleted your other post about Selenium (which nobody had responded to). Thank you! :slight_smile:

I don’t know what Selenium is, but maybe other people do! Or perhaps you may want to share with us what Selenium is?

3

I apologize. I forgot I posted here before. My bad. Didn’t check, getting old, need badly replacement, waiting for the AI butler any day in Amazon mail.

Selenium is for web browser based testing automation. However, besides that it is useful to automate tasks in the browser, like macros. I can record interactions with a form or website and then replay the steps. I use it for instance to delete things in batch, if a website doesn’t offer way to do it.

https://www.selenium.dev/

Browser version:

https://chrome.google.com/webstore/detail/selenium-ide/mooikfkahbdckldjjndioackbalphokd?hl=en

One of the uses is filling forms, however, to do that it requires scripts.

Where I would see use is have Airtable to feed the data and Selenium filling a form (e.g. 3rd party application form).

Once the form is filled in (once the button is pressed and the form is sent), I can reload the form and fill in with the next batch of data.

4

Haha! No worries! :stuck_out_tongue_winking_eye:

Oh, that’s very cool! I’ve gotta check this out! Thanks for the links & explanation! It even looks like they’re having a Selenium conference coming this month in my hometown of Chicago!

5

So I looked at this further because I am very interested in getting this working. I want to be able to fill in external forms using Airtable data. I posted on Airtable forums wondering if anybody uses anything. The challenge is to get the Airtable attachments to the 3rd party form uploaded.

I mentioned earlier Selenium (see above).

There is another more user friendly app Katalon based on Selenium https://katalon.com/ , but still requires working with code and this requires manual loading of CSV.

There is Axiom https://axiom.ai/ which is quite good but pricing is quite high to get Make or Zapier integration, although the lower tear works with Google Sheets.

And then there is https://browserflow.app/ which works via Google Sheets

The main issue I have is how to upload attachment images from Airtable to the web form. I have pictures I want to load to a web-form and that is not easy.

And there is even a quite complete list of tools for browser automation…

Bardeen is not listed there.

It only can do scraping but not webform filling.

.