Integrating with content from Google Sheets
The Content Library feature in CopyDoc allows you to use content snippets from a Google Sheet to populate your Figma text layers, which ensures that you can get up to date content directly from your Google Sheet URL whenever it’s loaded via the Integrations tab in CopyDoc.
Structuring your Google Sheet with text snippets
The format of the Google Sheet needs to follow the structure of: each column of your first/header row contains the trigger names (eg. //expandme
), with each text variant per snippet populating the rows underneath each trigger’s column.
//firstname | //cities |
---|---|
Kate | Seattle |
Elbert | Los Angeles |
Michael | New York |
Amy | Austin |
Portland | |
Boston |
Adding your Google Sheet to CopyDoc
In order to use your Google Sheet’s content snippets 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.
Once you’ve done that, to add your Google Sheets content snippets in CopyDoc, click on the Integrations tab in the Content Library panel, then select the Google Sheets option from the platforms dropdown selector; then you’ll need to paste your public Google Sheet URL (eg. https://docs.google.com/spreadsheets/d/2ds7EcUm9ZXQ2H0IXdGgOTtOfkhfpBKOsl5PSwANKuHE/edit?usp=sharing
) to automatically load the content.
Was this page helpful?