Syncing content to Figma from a Google Sheet

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.

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.

Importing Google Sheet spreadsheet to a Figma table

As well as syncing spreadsheet rows with Figma layers from a spreadsheet, the Sync Spreadsheet Content feature in CopyDoc allows you to sync repeatable text and image content from multiple rows from any spreadsheet (which can be an .xlsx/.csv file or a public Google Sheet URL) to your selected Figma layers.

Regardless of if you’re using an XLSX, CSV or Google Sheet for your spreadsheet, the structure is always the same; the very first row (or the “header”) of your spreadsheet is used as the first header row of the table (as the “component” row), and any rows underneath will become instances of that first header.

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.

Once the preview has loaded, and then click on the Generate a table in Figma from this spreadsheet button. This will import the content from your spreadsheet into a table on your current Figma page.