Issues creating or updating a Google Form from Airtable with Multiple Question Types for a mock exam tool

Questions
,
1

Hello community,

I am building a tool to automate the creation of mock exams for a business school. The source data is in Airtable and contains various question types (e.g., Multiple Choice, Short Answer, Paragraph).

My goal is to create a single Make.com scenario that can:

  1. Watch for new exam records in Airtable.

  2. Retrieve all linked questions.

  3. Dynamically generate a Google Form with the correct questions and question types.

Now Iam struggling with a robust mapping of the Airtable fields to Google forms in a robust way. I’ve tried the “create a form” module and the “update a form” module with adding a new item, but after one scenrario run the mapping is gone.

I guess my question is, is a real form building automation even possible with the Google Forms integration?

Thanks a lot.

Bildschirmfoto 2025-09-04 um 14.18.48
Bildschirmfoto 2025-09-04 um 14.18.484140×1444 302 KB

1 Like
3

Hi @Florian_Bockling,

sadly I don’t know the Google Forms API too well but as it’s been a few days without an answer, here is my general approach or maybe some things to check.

What’s the error message on the ‘Update a Form’ module?
What inputs expects the Google Form API and what output do you get from Airtable?
Does the Google Form ‘Update a Form’ expect only the updated values or the complete form data as it replaces the existing form?

I suppose the forms API expects an array of questions with their types potentially the answer options etc. You might need to create this kind of array in order to update the form.

Again, I don’t really know the Google Forms API but usually creating & updating forms dynamically isn’t the most trivial task as forms can be complex and thus the data structure required for the form too… :frowning:

Sorry, I couldn’t help more!

Best,
Richard

4

On option is to try building a form just with the API and a JSON object. If you’re able to do that, it will give you a framework for building it. You could then build your form out completely by transforming the airtable into the appropriate JSON object.

One thing I fn curious is this statement: after one scenrario run the mapping is gone.

Where and how do you store the mapping? Is there a way store it permantently so it isn’t updated every time? I’m guessing that if the mapping is stable it should make thing seasier all around.

L