The Scenario
The NPS survey closed Friday afternoon. 75 customers responded. Every response is in a Google Sheet: column A has the customer's email, column B has the feedback text they typed, column C has their pain score from 1 to 10.
The customer success lead wants all 75 responses in Productlane as feedback insights before Monday's team meeting so the product team can start triaging.
The bad version:
- Open Productlane, click "New Insight," paste the feedback text from the first row as the title, set the pain level, search for the customer by email to link the contact, and save.
- Repeat 74 more times.
- Realize after 20 that you have been using the wrong pain level scale — Productlane uses 0 to 5, not 1 to 10 — and now you have to go back and correct the first 20.
The product team is waiting on this data and the meeting is Monday morning.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads each row and calls the Productlane API to create an insight, linking it to the contact found by email and writing the returned insight ID back into column D as confirmation.
For each row in this sheet, create a Productlane insight using the feedback text from column A as the title, pain level from column B, and customer email from column C — write the insight ID into column D
What You Get
- Column D populated with the Productlane insight ID for every successfully created insight
- Any row where the email does not match a Productlane contact gets an error in column D (the insight is still created, just without a contact link)
- Any row where the pain level value is out of range gets a type error in column D so you can correct and re-run just that row
What If the Data Is Not Quite Ready
The pain scores are on a 1-10 scale and Productlane expects 0-5
Before creating insights, convert all values in column B from a 1-10 scale to a 0-5 scale (divide by 2, round to nearest integer) — write the converted value into column E and use column E as the pain level for each API call
Some feedback responses are blank
Before creating insights, check column A for empty cells — write "skipped: no feedback" into column D for blank rows — create insights only for rows with text in column A
The feedback text is too long to use as-is for the insight title
For each row, use the first 100 characters of column A as the insight title and the full text of column A as the insight body — create the Productlane insight with the truncated title and full body, and write the insight ID into column D
Full scale conversion, validation, and bulk create in one shot
Convert pain scores in column B from 1-10 to 0-5 scale and write into column E — skip rows where column A is blank and write "skipped" into column D — for valid rows create a Productlane insight using the first 100 characters of column A as the title, the full text as the body, the converted score from column E as pain level, and the email from column C to link the contact — write the returned insight ID into column D
75 feedback insights in Productlane before Monday, with a clean confirmation sheet.
Try It
Get the 7-day free trial of SheetXAI and open the NPS survey results spreadsheet, then ask it to create Productlane insights from all the responses. You can follow this by exporting the open insights list sorted by pain level to give the product team a prioritized triage view right away.