Note: Below, everything that applied to mv-storage could be applied to mv-source and mv-init as well.

1. Data must have headings:
   • in the first row of the specified range, if data is organized in rows (i.e., one row = one set of data)
   • in the first column of the specified range, if data is organized in columns (i.e., one column = one set of data).
2. The plugin can work with only one collection. If the app has more than one collection, only the first one will be used.
3. Property names inside the collection must correspond to headings in a spreadsheet. For example, if there is a row/column with the “year“ heading in the spreadsheet, to use data from this row/column inside the app, there should be the year property in the corresponding collection.

Note: The headings must contain only letters, numbers, and underscores (_). Otherwise, the transformHeadings option must be provided in the mv-storage-options attribute. In that case, the plugin will do its best to transform headings into allowed names of properties automatically. For example, the “Month name” heading will be transformed into “month_name”.

Share a spreadsheet and use the provided URL as a value for mv-storage and specify additional parameters via the mv-storage-* family of attributes if needed.

To write data back to the spreadsheet (if allowed by specified permissions), users must log in.

The plugin supports private spreadsheets as well. However, to read data from and write them back to a private spreadsheet, you must log in. The plugin won't let you work with other's private spreadsheets, only yours.

Note: You can find additional information about sharing a spreadsheet with the corresponding permissions in the Google Sheets help.

Note: We recommend providing either sheet title or range to avoid extra network requests.

This is a string like A1:B2 that refers to a group of cells in the sheet (the first visible sheet) and is typically used in formulas. For example, valid ranges are:

• A1:B2 refers to the first two cells in the top two rows of the sheet.
• A:C refers to all the cells in the first three columns of the sheet.
• 1:2 refers to all the cells in the first two rows of the sheet.
• A5:A refers to all the cells of the first column of the sheet, from row 5 onward.
• C2:2 refers to all the cells of the second row of the sheet, from column C onward.

Note: Named ranges are also supported.

The plugin supports a number of options for customizing the way it reads/writes data from/to a spreadsheet. You can specify these options by using the mv-storage-options attribute. To separate the options, you can use either commas or semicolons. For example, mv-storage-options="dataInColumns, transformHeadings".

<div mv-app="todoApp" mv-plugins="gsheets"
  mv-storage="https://docs.google.com/spreadsheets/d/14bzCuziKutrA3iESarKoj2o56dhraR8pzuFAuwTIo-g/edit?usp=sharing"
  mv-storage-sheet="Todos">

 <h2>Todo List</h2>
 <p mv-multiple="todo">
  <label>
   <input type="checkbox" property="done" />
   <span property="taskTitle"></span>
  </label>
 </p>
</div>

<div mv-app mv-plugins="gsheets"
  mv-source="https://docs.google.com/spreadsheets/"
  mv-source-spreadsheet="14bzCuziKutrA3iESarKoj2o56dhraR8pzuFAuwTIo-g"
  mv-source-range="1:2"
  mv-source-options="dataInColumns, transformHeadings">

 <h2>Data in Columns</h2>
 <p property mv-multiple>
  <span property="id"></span>
  <span property="value"></span>
 </p>
</div>