Ask HN: Need Help Brainstorming a Solution

#1

Post by chidog12 » Tue, Mar 31, 2020, 5:05 PM UTC

Need help brainstorming a solution to a little problem I'm having.

I have a google spreadsheet filled with rows of data that I need to copy and paste in some input fields on a website.

Current Manual Flow is: - Copy Cell A1, Paste in 1st input field on the website - Copy Cell A2, Paste in 2nd input field on the website - etc... - Click save button on website - Click New Page - Copy Cell B1, Paste in 1st input field on the website -etc...

I'm trying to think of ways to automate this process? Any tips or ideas would be a big help and save me A LOT of time!

Re: Ask HN: Need Help Brainstorming a Solution

#2

Post by juanjoo » Tue, Mar 31, 2020, 5:08 PM UTC

Nuevo comentario

Re: Ask HN: Need Help Brainstorming a Solution

#3

Post by verdverm » Tue, Mar 31, 2020, 5:26 PM UTC

there are several projects for browser automation, any should work for you if you can write some JS

Re: Ask HN: Need Help Brainstorming a Solution

#4

Post by sigmaprimus » Tue, Mar 31, 2020, 5:51 PM UTC

verdverm wrote: post #3

there are several projects for browser automation, any should work for you if you can write some JS

You could try Selenium IDE, it might require running an older version of FF and you might need to export your sheets data to CSV first.

https://medium.com/@kcmueller/browser-task-automation-with-f...

Or you might even be able to just automate the whole process using the IDE and the steps you laid out in your question.