This script fetches data from a google sheet and posts into KnackHQ objects which may or may not have connected fields. For posting into connected fields you will have to provide the field of the object that it is related to. This does not use any authentication as of now and can only fetch data from a published google sheet.
You can view a demo at: https://www.youtube.com/watch?v=Ng1scDCFgu8
- Imports data from google sheets.
- Can insert into connected objects.
- You have to provide the fields in the connected objects.
- Implementing using Google Sheets API.
- Saving rules for object transformations for further use.
- Scheduling for automatic posting data.
- Correction of wrong records.