The Scenario
You are a sales manager. The quarterly pipeline review just wrapped. You have a Google Sheet with 35 opportunities that need updated stages and revised deal values pushed back into Salesflare.
The review took three hours. The reps flagged deals that moved forward, deals that stalled, deals where the value changed after a negotiation call. All of it is marked in the sheet. Now it has to get into the CRM.
The bad version of this afternoon:
- Open Salesflare, search for opportunity 1
- Click the record, update the stage, update the value, save
- Back to the sheet, find opportunity 2, back to Salesflare, search for it, update, save
- Thirty-five times
- Around opportunity 20, you update the wrong record because the name was similar to another deal
- The CRM is out of sync with the sheet for a week before anyone notices.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads each row and pushes the update to Salesflare, so you do not have to touch the CRM interface at all.
Open the SheetXAI sidebar and type:
For each row in this sheet with opportunity_id in column A, new_stage_id in column B, and new_value in column C, update the Salesflare opportunity and write "updated" or the error message to column D.
SheetXAI iterates through the rows, calls Salesflare for each update, and writes the result to column D. You get a column of "updated" confirmations and any errors flagged inline.
What You Get
A completed sheet with column D filled:
- "updated" for every row that succeeded
- The error message for any row that failed, so you know exactly which ones to fix
No guessing whether the updates went through. Every row has a status, and every failure tells you why.
Want to re-run only the failed rows? Tell SheetXAI to filter to rows where column D is not "updated" and retry those. It does.
What If the Data Is Not Quite Ready
Pipeline review sheets come out of calls, not engineering sprints. They have inconsistencies.
When stage names are free-text instead of IDs
Reps typed "Negotiation" instead of a stage ID. Salesflare requires an ID to update stage correctly.
For each row in this sheet, look up the Salesflare stage_id for the stage name in column B, then update the opportunity in column A with that stage_id and the value in column C. Write "updated" or the error to column D.
When some values were left unchanged and you only want to update the stage
Not every deal had a value change. You want to update stage only for the rows where value is blank.
For each row in this sheet, update the Salesflare opportunity in column A. If column C has a value, update both stage and value. If column C is blank, update stage only. Write the result to column D.
When you want to add a note to each updated opportunity as a record of the review
The review decisions should be traceable. Attach the rationale to each opportunity record.
For each row in this sheet, update the Salesflare opportunity with the stage from column B and value from column C. Then add an internal note to the opportunity: "Pipeline review [today's date]: stage updated to [column B], value updated to [column C]." Write "done" or error to column D.
When the sheet has both won and lost deals that need different handling
Closed Won and Closed Lost opportunities need their actual close date set as well.
For each row, update the Salesflare opportunity stage and value from columns B and C. If stage is "Closed Won" or "Closed Lost," also set the close date to today. Write "updated" or the error to column D.
The pattern: the review sheet is the source of truth, the prompt pushes it all into the CRM at once, and column D is the audit trail.
Try It
Get the 7-day free trial of SheetXAI and open your pipeline review sheet, then ask it to push the updates to Salesflare. The Salesflare integration is included in every SheetXAI plan. See also how to bulk-create opportunities from a sheet or the Salesflare in Google Sheets overview.