Import setting
Link to google spreadsheet
Google Sheets link from which the data will be taken.
Sheet name
Sheet name in the Google Sheets.
Import type
- Default (creates new objects and updates found objects)
- Update (updates found objects)
- Create (creates new objects)
Model class
Default
Adds additional data to the retrieved data. Example:
text
[{"published":1,"parent":12}]Where
Criteria for filtering data from the table. Example:
text
[{"menuindex:<":6}]Unique field
Unique field that will be used to find the object.
Uses headers
Use header. If the table has headers, check the box to ignore the headers.
Fields
Fields to import are specified, separated by commas.
For example, for a resource:
text
pagetitle,longtitle,menuindex,tv.title