I'm so excited using Keyboard Maestro! Last week I stared using it to automate my little business and it already saved me like 20 hours of time. I even bought a Mac Mini today to continuously keep Keyboard Maestro running in the background.
Now, here's my problem:
Somehow I want to use a Spreadsheet document (or a CSV file for example) to fill in information on a certain website (in Google Chrome).
So: I want to get the first value in a Spreadsheet row and use it in the website. Then get the second value from the same spreadsheet row and use it in the website. Then save the information by clicking a button on the website. And next: move to the second row where the process will be repeated.
Can anyone please give me some pointers on how to get started in this? Is it by using parent and child functions? Or should I learn some Javascript (yikes!)? I've tried searching this forum but I think I don't know the right words to find the information I want.
I've been working on this issue a bit and have settled for using Google Chrome Tabs, of which the first Tab is a Google Spreadsheet (which I navigate by CMD-Copy Keystrokes and Right / Left / Down Arrow Keystrokes to navigate the database).
In the second Google Chrome tab I have the website where I Set "Google Chrome Fields to Text" and paste the clipboard.
The down and left keystrokes I use to go to the next line in the database. It's maybe a bit primitive setup but it's working like a charm so far
This is all embedded in a "Repeat Actions x Times" Control Flow.
