What are you trying to achieve?
Hello Make.com Community,
I’m new to Make.com, but I understand its capabilities and would love some help with setting up an automation.
I have two Google Sheets:
Student Preferences Sheet (Google Sheet 1):
This sheet records the test preferences of each student. Each row in the sheet corresponds to a unique student and contains two main pieces of information:
A student_ID, which uniquely identifies the student.
A list of unique_question_IDs, which represent the questions the student wants to be included in their test.
The sheet is updated dynamically, meaning new rows are added whenever a student enrolls. For example:
A row might show that student S001 prefers questions Q101 and Q102.
Another row might show that student S002 prefers questions Q103 and Q104.
Master Question Bank (Google Sheet 2):
This sheet is a repository of all test questions available. Each row contains:
A unique_question_ID, which corresponds to a question in the question bank.
The actual question_text associated with that ID.
For example, the question with ID Q101 might be “What is gravity?” and the question with ID Q102 might be “Define inertia.”
My Goal:
Using these two Google Sheets, I want to create customized Google Forms for each unique student. The form for each student should contain only the questions that match the unique_question_IDs listed in the Student Preferences Sheet for that student.
Questions for the Community:
How can I use Make.com to automate this process?
What modules and logic should I use to:
Match the unique_question_IDs in the Student Preferences Sheet with the corresponding questions in the Master Question Bank?
Dynamically generate a Google Form for each student, containing the specific questions they prefer?
I’d appreciate any guidance, examples, or tips to help me set up this automation. Thank you so much for your help!
Steps taken so far
Help me please.