Auto-submit your weekly portal report from a spreadsheet
Every Monday an AI browser agent reads the next row from your spreadsheet, logs into the portal, submits the form for you, and Slacks the confirmation.
Every Monday at 8am, automatically submit our recurring web-portal report so nobody has to re-key the same numbers by hand. This is a fixed, deterministic pipeline, so build it as a code workflow where every step is a known node: read one pending row, run one browser task with those values, write the result back, and notify.
Start with Google Sheets Get Values to read the next pending submission row from the tracking sheet. Each column holds one of the form field values, plus there is a status column. Select the first row whose status is empty or Pending, so a row that was already submitted is never picked up again.
Pass those column values to a Browser Use agent task with Run Agent Task. The task should use a saved Browser Use login profile so it does not have to re-authenticate the portal each week, then log into the vendor or government portal, fill the required web form with exactly those values, and submit it. Instruct the agent to return the confirmation or reference number the portal shows after a successful submission, and to report whether the submission actually succeeded.
Because Browser Use tasks run asynchronously, poll Get Session until the session leaves the running state, then read its output and its task success flag.
If the task reports success and returns a confirmation number, use Google Sheets Update Values to write that confirmation number plus the current timestamp back into the same row and set its status column to Submitted, so the row can never be submitted twice. Then post a Slack confirmation to the operations channel with Send a Message that includes the row identifier, the confirmation number, and the timestamp.
If the task reports that it was not successful, leave the row unmarked. Do not set the status to Submitted and do not write a confirmation number, so the row will be retried on the next run. Instead, post a Slack alert to the operations channel with Send a Message so someone can step in and complete the submission manually.
Additional information
What does this prompt do?
- Reads the next pending submission from your Google Sheet, treating each column as the exact value for a field on the web form.
- Sends an AI browser agent into the vendor or government portal with your saved login, then fills and submits the form for you.
- Writes the confirmation number and a timestamp back to the row and marks it Submitted, so the same report is never sent twice.
- Posts a Slack confirmation when it works, and a Slack alert when it does not, so your team can step in.
What do I need to use this?
- A Google Sheet with one row per submission, a column for each form field, and a status column to track what has been sent.
- A Browser Use account with a saved login profile for the portal you submit to.
- A Slack workspace and the operations channel where your team wants updates.
How can I customize it?
- Change the schedule from Monday at 8am to any cadence you need, whether daily, weekly, or monthly.
- Point it at a different portal by swapping in the saved login profile and the form fields it fills.
- Choose which Slack channel receives the confirmations and the alerts.
Frequently asked questions
Do I need coding skills to set this up?
How does it avoid submitting the same report twice?
What happens if the portal login fails or the form will not submit?
Will this work on a portal that has no API?
Does it need my password every week?
Related templates
Stop re-keying the same portal report every week.
Let an AI browser agent read your spreadsheet, submit the form, and confirm it in Slack, on schedule, every week.