Import Google Sheets (For Variables)

Import Google Sheets (For Variables)A plugin that allows you to import Google Sheets into a Figma collection (variables). Supports synchronization to multiple modes, not just single mode.

View the code on GitHubGoogle Sheets APIhttps://sheets.googleapis.com/v4/spreadsheets/${SHEET_ID}/values/${RANGE}?key=${TOKEN}To create an API URLopen the Google Sheets you want to synchronize with Figma.click the "Share" button in the top right corner, and select "Everyone with the link" from the general access.

Get the ${SHEET_ID} of the Google Sheets link in your browser's address bar.

Set ${TOKEN} by issuing an authorization token in Google Cloud Manager settings. (https://admin.google.com)Set the scope for the rest of the data except for the columns (e.g. A2:D).set ${RANGE} to a string that is the sum of the sheet name and the above range.

Sample URLhttps://sheets.googleapis.com/v4/spreadsheets/1iYOtMl4nqwtEgBWq4_B0EcIoSB5bc77OOhPzsm79nIc/values/Sheet1!A2:D?key=AIzaSyA5xA59tkljcFItKX3JDhJ6Dr-Ng8_PmVkSet up the restEnter a name for the collection. If the collection exists, delete it and add it again.

Except for the variable names, describe the modes (columns) separated by commas.