Best way to write data to Google Spreadsheet?

[Anurag Prasad]

Hi,

I am trying to post HTML form data to google spreadsheet. I have been using this module- https://www.npmjs.org/package/edit-google-spreadsheet

However I am getting a "JSON Parse Error: SyntaxError: Unexpected end of input" error. I have used the exact example as given in the documentation. 

Is there any other way by which I can achieve this purpose?

Thanks and regards,

Anurag Prasad

[Marko Bozic]

Hi Anurag.

The problem is in the new google spread sheet. I have two spread sheets - one old and one new. The old is working perfectly and the new shows the same error as yours. I copied the old spreadsheet (when you copy an old spreadsheet the result is a old spreadsheet) and used NodeJs to write in it. It works for now. 

If you find out how to use edit-google-spreadsheet with this new spreadsheet please let me know. 

I hope it helps.