Video Tutorial: Use Google Sheets as a Figma text content library
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.