Documentation Index

For the complete documentation index, see llms.txt. Markdown versions of docs pages are available through the page's alternate Markdown link.

Current page: Syncing content to Figma from a Google Sheet - If you've created your spreadsheet as an Google Sheet, you can sync it with your Figma design.. Machine-readable page: /copydoc/sync/google-sheets.md.

Syncing content to Figma from a Google Sheet

If you've created your spreadsheet as an Google Sheet, you can sync it with your Figma design.

Video Tutorial: Sync Google Sheets spreadsheet content to Figma

This video tutorial is a complete step-by-step guide showing you how to sync content from a Google Sheets spreadsheet to your Figma designs using the CopyDoc plugin.

Video Tutorial: Auto repeat and sync Figma layers from a spreadsheet

This video tutorial is a complete step-by-step guide showing you how to automatically repeat and sync Figma layers from a spreadsheet using the CopyDoc plugin.

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 Content button in the main CopyDoc plugin screen, which will open up the settings panel for this feature.

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.

If you're unable to set the permissions to Anyone with the link can view (due to company policies), you can still edit your sheet in Google Sheets, then download it to a local Excel (.xlsx) file on your computer, which you can drag and drop the Excel file directly into the Figma plugin and that will give you the exactly same result as if it was loaded remotely from the Google Sheet URL instead.

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.

Figma text layers with missing fonts can't be updated. If your Figma text layer contains a missing font, the plugin won't be able to update it. Please ensure any text layers you would like to update in any way using the CopyDoc plugin have their missing fonts resolved.

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.