What is your goal?
Build a CV screening workflow that extracts candidate data from PDFs using Gemini AI and writes all extracted fields (name, email, phone, years experience, top skills, education, previous jobs, score, red flags, recommendation) to a Google Sheet.
What is the problem & what have you tried?
-Gemini API returns perfect JSON with all 10 fields
-JSON Parser (Module 35) successfully parses all data - OUTPUT shows all fields with correct values
-Google Sheets module (9) is mapped to all 10 fields from Module 35
- But only 5 fields appear in the spreadsheet (email, phone, education, score, recommendation)
- Missing fields: name, years experience, top skills, previous jobs, red flags
What I’ve Tried:
- Deleted and rebuilt Google Sheets module multiple times
- Verified all mappings point to Module 35 (purple pills, not Module 30)
- Used join() function for array fields (top_skills, previous_jobs)
- Checked flow connections: Router → JSON Parser → Google Sheets (all connected correctly)
- Verified no filters blocking the flow
- Enabled “Parse response” in HTTP module
- Set JSON Parser “Strict” to NO
- Tested with fresh data multiple times
Why would Make’s Google Sheets module only send SOME fields from a JSON Parser to the spreadsheet when:
All fields are present in the JSON Parser OUTPUT
All fields are mapped in the Google Sheets configuration
No errors are shown
But only 5 out of 10 fields appear in the INPUT bundle and final spreadsheet?
Is there a known issue with certain field types not being passed through routers, or a configuration I’m missing?
When I check Module 9 INPUT bundle, it only shows 5 fields being sent to Google Sheets, even though Module 35 OUTPUT clearly shows all 10 fields with data. It’s like Module 9 isn’t “seeing” all the fields from Module 35, despite being mapped to them.
Error messages or input/output bundles
{
“name”: “Sarah Martinez”,
“email”: “sarah.martinez@email.com”,
“phone”: “+1-415-555-0198”,
“years_experience”: 8,
“top_skills”: [“Product Strategy”, “Agile/Scrum”, “User Research”, “Data Analysis”, “Roadmap Planning”],
“education”: “Master of Business Administration (MBA)”,
“previous_jobs”: [“Senior Product Manager at TechFlow Solutions”, “Product Manager at DataSync Inc”, “Associate Product Manager at CloudWorks Technologies”],
“score”: 9.5,
“red_flags”: “None”,
“recommendation”: “Interview”
}
**Module 9 (Google Sheets) INPUT - Only shows 5 fields:**
Candidate Email (E): sarah.martinez@email.com
Phone (F): +1-415-555-0198
Education (I): Master of Business Administration (MBA)
Score (K): 9.5
Recommendation (M): Interview
Missing from INPUT bundle:
Candidate Name (B)
Years of Exp (G)
Top Skills (H)
Previous Jobs (J)
Red Flags (L)
No error messages - all modules show green checkmarks.
Create public scenario page
Screenshots (scenario flow, module settings, errors)
