Create a bot - fill in a form using a table and save the outcome
- or -
Post a project like this£50(approx. $63)
- Posted:
- Proposals: 12
- Remote
- #4171343
- Expired
⭐ TOP RATED ⭐ Graphic Designer| WordPress / WIX |2D Animator| Video Editing |Photoshop Expert
Karachi
Graphic Designer |Experienced Web Designer | Video/Audio Editor | PowerPoint/Keynote | Content Writer |
San Jose
Email Marketing/Campaign||Email Deliverability||CRM Developer||Email Template Design||HTML Email Template Design
Paris
"Digital Architect: Turning Visions into Reality with Cutting-Edge Marketing Strategies, Creative Design, and Web Development"
Sorocaba
124641325568313306174343141670577759143232106602221089891911028246110470131106625211076870
Description
Experience Level: Entry
Hello,
I need an automation/bot to:
- Automatically run every day
- Fill out an online form for each row in a Google Sheet table
- After submitting the form, take a screenshot and download files from the page that is displayed
- Save the screenshot and files in Google Drive following a naming format
- Produce a report for any rows that failed
In more detail:
- A Google sheet exists with approximately 50 rows of data. The records within this table are regularly updated
- Specific cells from each row are used to fill in an online form
- Open the link in a browser
- Click on another link and click an “I agree” box
- Open the Google Sheet table. Take the first row
- Fill out some of the details on that page using data in the table (I believe the form is Javascript)
- A page is displayed. Take a screenshot of this window. Save the screenshot to Google Drive using the format “YYYY.MM.DD HH:MM - LastName(FromGoogleSheet) LastName(FromGoogleSheet) PostCode(FromGoogleSheet) - Details”
- Two boxes can be clicked on at the bottom of the page.
- Click on the first box.
- Take a screenshot. Name it as above but with “Allowance” at the end.
- There is an ‘Export to CSV’ option. Click on that. Save the file in the same format with “Allowance CSV” at the end.
- Go back a page and click on the second box
- Take a screenshot. Name it as above but with “Payment” at the end.
- There is an ‘Export to CSV’ option. Click on that. Save the file in the same format with “Payment CSV” at the end.
Repeat for the second row. And so on.
Create a list of any of the rows that failed to progress to the page after the form has been completed and email it to me each day.
Please quote "BFL2902" at the start of your message so I know you have read and understood the brief. Thank you.
I need an automation/bot to:
- Automatically run every day
- Fill out an online form for each row in a Google Sheet table
- After submitting the form, take a screenshot and download files from the page that is displayed
- Save the screenshot and files in Google Drive following a naming format
- Produce a report for any rows that failed
In more detail:
- A Google sheet exists with approximately 50 rows of data. The records within this table are regularly updated
- Specific cells from each row are used to fill in an online form
- Open the link in a browser
- Click on another link and click an “I agree” box
- Open the Google Sheet table. Take the first row
- Fill out some of the details on that page using data in the table (I believe the form is Javascript)
- A page is displayed. Take a screenshot of this window. Save the screenshot to Google Drive using the format “YYYY.MM.DD HH:MM - LastName(FromGoogleSheet) LastName(FromGoogleSheet) PostCode(FromGoogleSheet) - Details”
- Two boxes can be clicked on at the bottom of the page.
- Click on the first box.
- Take a screenshot. Name it as above but with “Allowance” at the end.
- There is an ‘Export to CSV’ option. Click on that. Save the file in the same format with “Allowance CSV” at the end.
- Go back a page and click on the second box
- Take a screenshot. Name it as above but with “Payment” at the end.
- There is an ‘Export to CSV’ option. Click on that. Save the file in the same format with “Payment CSV” at the end.
Repeat for the second row. And so on.
Create a list of any of the rows that failed to progress to the page after the form has been completed and email it to me each day.
Please quote "BFL2902" at the start of your message so I know you have read and understood the brief. Thank you.
Edward P.
100% (49)Projects Completed
60
Freelancers worked with
56
Projects awarded
27%
Last project
6 Oct 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies