Inserting data into Google Sheets

[jmcgarry]

Hi,

This is my first go at this, all I want to do for now have the data from a jot form added to a google sheet. I seem to be entering {} values into the sheet.

I have tried to map the fields from the from to the Google sheet but I do not think this is working, see attached image.

I get empty list where I assume I should be seeing a form field name.

Any help appreciated

John

[menacestudio]

@jmcgarry can you click on “test” on your Jotform submission trigger, and try submitting some data? It looks like there’s no incoming data, which is the issue.

[jmcgarry]

HI

I did the test , see below, it appears to be bring in null value, see bottom right hand corner of image, I have setup the api key, it can see the actual spread sheet but not the field values it appears.

Cheers

John