“Need help connecting OpenAI and Google Sheets (DLL Generator for Teachers)”

:puzzle_piece: What I’m building:
I’m creating a DLL Generator using Google Sheets and OpenAI via Make.com.

:white_check_mark: Goal:
When a user submits a form, their input goes to Google Sheets. Then, Make.com sends it to OpenAI to generate lesson procedures, and outputs it back into the same row.

:warning: Problem:
The row number doesn’t update correctly — the “Generated_DLL” column doesn’t populate.

:hammer_and_wrench: What I’ve tried:

  • Used Set Variable module to store row number
  • Replaced row reference with {{13.rowNum}} but didn’t work

:camera_with_flash: Screenshots:
[Insert screenshots of modules and error]