The Scenario
You are a sales rep. You spent the last two weeks on the road, visiting 20 customer accounts. You kept your meeting notes in Google Calendar and exported them into a spreadsheet: company name, contact email, meeting date, and subject line, one row per meeting.
None of these meetings are logged in Salesflare yet. If they are not in the CRM, they do not exist for your manager, for your quota attainment, or for the next rep who picks up this territory.
The bad version of this Monday:
- Open Salesflare, search for account 1 by company name
- Click the account, find the "Log Activity" button, select "Meeting," fill in the contact, the date, and the subject, save
- Search for account 2, repeat
- Twenty times
- On meeting 14, Salesflare logs the meeting under the wrong account because the company name matched two records
- Your manager looks at the CRM and thinks you were in the office all week.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads each row and logs the meeting record in Salesflare against the right account, so you do not have to touch the CRM interface once.
Open the SheetXAI sidebar and type:
For each row in this sheet with account_id in column A, contact_id in column B, meeting_date in column C, and subject in column D, create a Salesflare meeting record and write the returned meeting_id to column E.
SheetXAI creates the meeting record for every row against the right account and contact, and writes the meeting_id back to column E. Twenty meetings logged, with a receipt in the sheet.
What You Get
A completed sheet with column E filled:
- Column E — the Salesflare meeting_id for every logged meeting
Every meeting is attached to the correct account and contact from the same row. The IDs in column E are the proof.
Want to confirm one? Ask SheetXAI to fetch the meeting details for any ID in column E and verify the account and date match.
What If the Data Is Not Quite Ready
Calendar exports are messy. Subjects are inconsistent, dates are in the wrong format, and account names do not always match CRM records.
When you have company names but not Salesflare account IDs
The calendar export does not include CRM IDs, just the company name you typed in the meeting invite.
For each row, search Salesflare for an account matching the company name in column A. Write the found account_id to column E. Then search for a contact matching the email in column B and write the contact_id to column F. Then create the meeting record using columns C and D, and write the meeting_id to column G.
When meeting dates came out of the export as text instead of dates
The calendar export formatted dates as "April 15, 2026" or "15/04/2026" instead of a standard format Salesflare accepts.
Normalize the date formats in column C to YYYY-MM-DD before logging the meetings. Then create the Salesflare meeting records and write the meeting_ids to column E.
When subjects are too raw to be useful CRM records
The calendar subjects are things like "Call" or "Chat" because you created events quickly. Before logging them, you want to rewrite them to something more descriptive.
For each row, use the subject in column D and the company name in column A to write a cleaner meeting subject in the format "[Company Name] — [topic] meeting." Then create the Salesflare meeting record using the cleaned subject and write the meeting_id to column E.
When you want to log the meetings and add a note summarizing the outcome in one shot
Your call notes sheet has a fifth column with outcome notes. Log the meeting and attach the note at the same time.
For each row in this sheet, create a Salesflare meeting record using account_id, contact_id, date, and subject from columns A through D. Then create an internal note on the same account with the outcome text from column E. Write the meeting_id to column F and the note_id to column G.
The pattern: the calendar export drives the logging, the IDs come back to the sheet, and the CRM reflects the work you actually did.
Try It
Get the 7-day free trial of SheetXAI and open any sheet with meeting data, then ask it to log the records in Salesflare. The Salesflare integration is included in every SheetXAI plan. See also how to bulk-add call notes from a sheet or the Salesflare in Google Sheets overview.