The Scenario
Your company just rolled out a credential-rotation policy — every employee with a Make account needs to reset their password by Friday. The IT admin (that's you) has 40 user email addresses in column A of a compliance tracking sheet. The policy says you need to log each successful reset request in column B.
On Tuesday you tried doing this manually through Make's admin UI. You got through 12 users before Make's session timed out and you had to log back in. On Wednesday morning you started again and realized you'd lost track of where you were in the list.
The bad version:
- Log into Make's admin panel, navigate to User Management, search for user 1, click "Send Password Reset," wait for the confirmation, go back
- Repeat 39 more times — tracking which row you're on in the spreadsheet, switching windows, hoping the session doesn't time out again
- Discover on Thursday that three users never got the email because you accidentally skipped their rows during a window-switching error
You need this done before the audit window closes on Friday. Re-doing it row by row a third time is not the plan.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the email addresses in column A and triggers Make password-reset requests for each one in a single pass, writing the result back to column B.
With your email list in column A, run:
Send a Make password reset email for every user email address in column A of this sheet and mark column B as 'sent' for each successful request
What You Get
- Column B fills with "sent" for each address that returned a successful response from Make
- Any address that returned an error gets an "error" note in column B with the status code, so you know exactly which ones need follow-up
- The operation runs across all 40 rows in one pass — no session management, no window switching
- The compliance sheet is ready to hand to the audit team without a separate pass to document which users were processed
What If the Data Is Not Quite Ready
What if some rows in column A are blank and I want to skip them?
Send a Make password reset email for every non-blank email address in column A and write 'sent' or 'error' in column B for each row processed — skip any blank rows
What if I want to log the timestamp of each reset request in column C?
Send a Make password reset email for every email address in column A, mark column B as 'sent' or 'error', and write the current timestamp in column C for each row processed
What if some emails are already marked 'sent' from a previous partial run and I want to skip those?
Send a Make password reset email for every email in column A where column B is not already 'sent' — write 'sent' or 'error' in column B for each newly processed row
What if I need to process the full list, log the result per row, and then generate a summary row at the bottom showing total sent, total errors, and total skipped — all in one pass?
Send a Make password reset email for every non-blank email in column A that doesn't already have 'sent' in column B — write the result in column B for each row, then add a summary row at the bottom showing the count of sent, error, and skipped rows
The approach: combine the bulk operation, the per-row logging, and the summary in one prompt so the compliance sheet is complete when the run finishes.
Try It
Get the 7-day free trial of SheetXAI and open the compliance sheet with your Make user email list, then ask it to trigger the password resets and log each result. Also useful: auditing org-and-team inventories, or pulling 30-day usage data for billing reports — both covered in the Make integration overview.