Google Forms [Watch Response in Google Sheets} doesn't update columns metadata

How To
,
1

Hi there,

I just setup a Google Forms module: “Watch responses in Google Sheets”. At first time, my scenario recognized the metadata of the Google Sheet generated from the Google Form, with 26 columns (26 questions).

After some hours, I added more 2 questions to my form and then created 2 new columns (headers) on Google Sheets Response.
The problem is that my scenario doesn’t update header metadata. To solve this temporally, I have added 2 cell lookups to search for the new data on these columns.

My scenario and my Google Sheets Module:
image

The last column available for data-map is the “Z” column:

image
image626×631 62.7 KB

My Google Sheet headers:
image

Is there any way to update headers metadata in Google Forms module?

2

Welcome to the Make community!

Generally you should avoid changes that modifies the columns in Sheets.

What I would try here is delete the module and add it back.

samliew – request private consultation

Join the unofficial Make Discord server to chat with us!

1 Like
3

Hi there,
Just updating this post about the solution:

By default, the google forms module fetch the A:Z range in the response’s spreadsheet. To expand the range, it’s necessary to toggle on “Show advanced settings”, then insert the correct range.

3 Likes