Error in making a form with the Google Sheet API

[astrogewgaw]

So I tried connecting a form to a Google Sheet (following the steps in the lowdefy tutorial) and I am running into this weird error: Request Error: cleanRows received invalid input type undefined.. How do I resolve it? I have no idea where the problem is, so I don't know where to look for solutions 😅. My code is all here: https://github.com/astrogewgaw/whoswho.

[Gervwyk]

Hi @astrogewgaw
I ran your code and it worked fine on my side. I did not have to change anything.
https://docs.google.com/spreadsheets/d/1wldNzkdP7-qSBz8pdtYrx8dlTw01vqQ9gn6KfXPg5DU/edit#gid=801663685

The only thing I needed to do is add the header row to the google sheet.
Perhaps just double check your sheetId and spreadsheetId? For the above link mine is:

connections:
  - id: google_sheet
    type: GoogleSheet
    properties:
      client_email:
        _secret: SHEETS_CLIENT_EMAIL
      private_key:
        _base64.decode:
          _secret: SHEETS_PRIVATE_KEY
      spreadsheetId: '1wldNzkdP7-qSBz8pdtYrx8dlTw01vqQ9gn6KfXPg5DU'
      sheetId: '801663685'
      write: true

Please let me know how it goes?

[astrogewgaw]

My bad 😅 @Gervwyk ! Turns out i had to keep the names of the headers in the sheet the same as the headers used in the lowdefy config. I inferred that since it was just appending a row it didn't matter if I changed the header names in the sheet. The form is working now 👍🏾 !

[astrogewgaw]

Basically, keep the header names the same throughout, both in the Google Sheet and in the YAML configuration for the form you are building 👍🏾 .

[SamTolmay]

Yes. The column headings need to match the field names of the row object you are trying to append. This means those fields don't need to be in a specified order, and some fields can be missing.