Google spreadsheet integration: Modifications

I have a form integrated with google drive and google spreadsheets.

After using for a few months, I had to include a new field in the form, and the google spreadsheet that was sharing the information, stopped receiving the data.

1. How to include new fields and update google worksheet automatically?

2 How to change the field type?

Example:

Text box for drop-down menu

When you make a change to your form or to your spreadsheet it will break. The smallest change can break the integration.

Have you tried removing your current integration and integrating again? It should update properly.

Finally, I don't believe its possible to change the field type and keep your existing data. When you delete a field then all data associated with that field is gone. Best you can do is keep your old field and hide it on your form.

How-to-Hide-Form-Fields

Then add a new field for the new data (that is visible).