Video Tutorial: Sync Google Sheets spreadsheet content to Figma
Video Tutorial: Auto repeat and sync Figma layers from a spreadsheet
Syncing your Google Sheet content to Figma layers
If you've created your spreadsheet as a Google Sheet, you can sync it with your Figma design by clicking on the Sync Spreadsheet button in the main CopyDoc plugin screen, which will open up the settings panel for this feature.
Making your Google Sheet link public and copying the URL
In order to use your Google Sheet's content to sync with Figma, you'll first need to ensure that the Google Sheet share URL is made public, otherwise the plugin won't have permissions to read it. You can do this by opening up the spreadsheet in Google Sheets, clicking the Share button and changing the sheet's permissions from Restricted and update it to Anyone with the link.
Pasting your Google Sheet URL and syncing with Figma
You can preview your spreadsheet contents by pasting your public Google Sheets URL into the Sync Public Google Sheet input field; if it's a valid, and public URL that's correctly structured, it will automatically load a preview of the headers that it contains after pasting it.
Ensure that you select at least one layer in Figma that contains renamed layers to match your spreadsheet headers, and then click on the Sync Spreadsheet Rows with Figma Layers button. This will sync the content from your spreadsheet with your selected renamed Figma layers.
Auto repeat a single Figma layer with your spreadsheet rows
When using the Content or Styles sync tab options, you can automatically repeat a single Figma layer by enabling the Auto Repeat toggle, which will automatically copy the original selected Figma layer and duplicate it as many times as the number of rows that your spreadsheet data contains.
If your selected Figma layer is already directly inside of another Figma layer with Auto Layout enabled, the selected layer will automatically be duplicated inside of that parent layer, otherwise, CopyDoc will create a brand new Auto Layout frame and duplicate your new Figma layers there instead.
Dynamic auto-repeating parent layer names
If you'd like to dynamically name the new auto-repeating Figma layer from your spreadsheet data, too, you can do this by ensuring the Figma layer name that you're repeating (eg. #Title) matches a column in the spreadsheet that you're syncing; this will automatically use the value from each row under the #Title column in your spreadsheet as the layer name for each duplicated Figma layer.
If there's no matching layer name in your spreadsheet, the CopyDoc plugin will take the original Figma layer name and append a row number to it (eg. My Frame Layer (Row 3)) instead.