The Scenario
A research consultant ran 5 separate client satisfaction surveys over the last quarter — one per client engagement. The survey IDs are in a Google Sheet. Now she needs all 800 total responses from across those 5 surveys merged into one master sheet with a column that identifies which survey each response came from. The analysis starts tomorrow and the client expects a cross-survey breakdown.
The bad version:
- Go to SurveyMonkey, export responses for survey 1 as a CSV, open it, add a SurveyName column, fill it in, save.
- Repeat for surveys 2 through 5, each with slightly different question structures so the column headers don't match.
- Try to combine the five CSVs in a single sheet, realize the header rows conflict, spend 45 minutes manually aligning columns and deciding what to do about questions that appear in some surveys but not others.
The analysis is due to the client at end of week. The merge is not the analysis — it is just the prerequisite. The 45 minutes she spends on it are 45 minutes she is not spending on the actual work.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the survey IDs from the sheet, fetches all responses for each one, and appends them to a master output tab with a source column — handling the column alignment automatically.
For each survey ID in column A of this sheet, fetch all bulk responses from SurveyMonkey and append each response as a row in a new sheet named 'All Responses', adding a SurveyTitle column as the first column to identify the source survey. Use question text as column headers.
What You Get
- A new tab named 'All Responses' with all responses from all surveys combined.
- SurveyTitle as the first column on every row, identifying which survey that respondent came from.
- Question text used as column headers (not question IDs), with columns appearing once — responses for questions not present in a given survey left blank for that row.
- Rows appended in survey order, one respondent per row.
What If the Data Is Not Quite Ready
Some surveys have different question sets — you want to flag columns that are sparse
Fetch all bulk responses for each survey ID in column A and append to 'All Responses' with a SurveyTitle column. After writing all rows, add a row at the bottom labeled 'FILL RATE' that shows the percentage of non-blank values in each column, so you can see which questions were asked across all surveys versus only some.
You only want completed responses, not partials
For each survey ID in column A, fetch only completed SurveyMonkey responses (completion status = complete) and append to 'All Responses' with a SurveyTitle column. Write total response count per survey into a 'Source Summary' tab.
You want a per-survey response count summary alongside the master data
For each survey ID in column A, fetch all bulk responses and append to 'All Responses' with a SurveyTitle column. After all surveys are processed, write a summary table to the 'Survey Summary' tab showing survey title, survey ID, and response count for each survey.
You need the full merge with completion filter, fill rate, per-survey summary, and date range — all in one prompt
For each survey ID in column A, fetch only completed SurveyMonkey responses submitted after 2026-01-01. Append all responses to 'All Responses' with SurveyTitle as the first column and date submitted as the second column. After the merge, write to a 'Summary' tab: survey title, total responses, and date range (earliest to latest submission) for each survey. Add a FILL RATE row at the bottom of 'All Responses' showing the percentage of non-blank values per column.
One instruction handles the multi-survey pull, the filter, the date range, the summary tab, and the fill rate check.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet with your list of survey IDs, then ask it to pull all responses across surveys and merge them into a single master sheet with a source column. For pulling responses from a single survey, see the spoke on bulk-exporting survey responses. For the full SurveyMonkey overview, see the hub page.