0
100
200
300
400
500
600
700
800
900
1000
1100
0
100
200
300
400
500
600
700
800
900
1000
1100
Figma plugin#11 in Tables

Spreadsheet Sync

Design smarter: use real data from your spreadsheets in Figma

by Andre Pinto

users
10K
likes
183
saves
2.9K
comments
59
FreeWorks inFigma Design
Price
Free
Latest version
v17 ยท Oct 6, 2021
First published
Apr 20, 2021
Publisher
Andre Pinto
Features

What Spreadsheet Sync does

Summarised from Andre Pinto's description on the Figma Community.

  • SHARE THIS IF YOU LOVE IT! LETS MAKE THE BEST PLUGIN TO HELP THE COMMUNITY!

    --------

  • STEP 1

    Your Google Spreadsheet has to be public

  • STEP 2

    Use the correct naming on your Figma layers.

  • Google Sheets example

    | Title | Variant | Fill Color | Stroke | Hidden | Image |

  • Figma layer naming example

    | ------------------------ |

  • STEP 3

    Paste your Google Spreadsheet link (copy from browser address bar), select the amount of layers and click Sync.

  • EXTRA

    ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ Use the "Preview" button for an advanced usage (little blue button with eye icon next to the url input).

  • EXAMPLES

    Figma File. Google Spreadsheet (example card)

  • Manifest

    2 quick actions

    Run from the Actions menu (Cmd/Ctrl + K): Open Spreadsheet Sync, Re-sync Spreadsheet Data.

On this page
Overview

About Spreadsheet Sync

Spreadsheet Sync is a free Figma plugin published by Andre Pinto in 2021. It works in Figma Design and has 10,075 users and 183 likes on the Figma Community. It ranks #11 in Tables and #14 in Mock Data & Content on our lists.

In the developer's words

๐Ÿงฉ Use dynamic data on your Figma from Google Spreadsheets.

๐Ÿ”ฅ Fast data replace from Google Spreadsheet.

๐Ÿ˜Ž Use Google Sheets as dynamic data on your design.

โœ… Works with Components, Frames, Layers... all (as long as the layer has sub-layers/children).

โฌ‡๏ธ โฌ‡๏ธ โฌ‡๏ธ CHECK THE STEPS BELOW โฌ‡๏ธ โฌ‡๏ธ โฌ‡๏ธ

Not affiliated with Google โ€ข Created with โค๏ธ by Andrรฉ Pinto

If you want to support the continued development of this plugin, why not buy me a coffee at:

ko-fi.com/apinix

SHARE THIS IF YOU LOVE IT! LETS MAKE THE BEST PLUGIN TO HELP THE COMMUNITY!

--------

STEP 1:

Your Google Spreadsheet has to be public

  1. Share > Get shareable link

STEP 2:

Use the correct naming on your Figma layers.

AUTO RENAMING...Rename manually or use the new renaming by clicking on the table (when on advanced mode).

MANUALLY RENAMING... add a # prefix followed by the name of the column you want to sync (ex: #Title).

You can nest multiple columns in one layer (Note: it is not case sensitive, and will ignore spaces).

Google Sheets column example names: (ex: Sheet / Figma)

  1. Text (Just text)
  2. Fill Color (/#E24A08)
  3. Stroke Width and Color (/2|#E24A08) or (/|#E24A08)
  4. Show (/Show)
  5. Hide (/Hide)
  6. Image (http://image-path...)
  7. Multiple (#Name#Color#Show)
  8. Multiple with Placeholders (layer name: #Value1#Value2 -> actual text: 'This is {#Value1} and is in the same sentence of {#Value 2}')

Google Sheets example:

| Title | Variant | Fill Color | Stroke | Hidden | Image |

| --------------- | ----------- | ---------- | ---------- | ------- | ----------------- |

| This is a title | Color=blue | /#ff0000 | /2|#ff0000 | /Show | http://image-path |

| This is a text | Color=green | /#0099ff | /|#0099ff | /Hide | http://image-path |

Figma layer naming example:

| ------------------------ |

| #Title | -> normal text replace

| ------------------------ |

| #Color.randsave | -> gets a random value from a random "saved" row (if you want to use the same random row on another layer)

| ------------------------ |

| #Hidden | -> hides or shows layer

| ------------------------ |

| #Image.rand | -> gets a random value

| ------------------------ |

| #Title.1#Color.randsave | -> text replacement and the same random saved color from before (if under the same selection))

| ------------------------ |

STEP 3:

Paste your Google Spreadsheet link (copy from browser address bar), select the amount of layers and click Sync.

EXTRA:

๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ Use the "Preview" button for an advanced usage (little blue button with eye icon next to the url input).

  1. You can rename layer(s) with just a click
  2. You can even multiple rename layers if you click SHIFT key

--------

EXAMPLES:

  1. Figma File
  2. Google Spreadsheet (example card)
  3. Google Spreadsheet (example table)
Changelog

What's new

Version 17 ยท released Oct 6, 2021

  • โœ… Now with multiple sheet support
  • โœ๏ธ Advanced mode with multi layer renaming
  • ๐Ÿ“ Advanced mode now can be resized
  • ๐Ÿซ Color with stroke weight possible now
  • ๐Ÿงฉ Better layer string inside text implementation
  • ๐ŸŒ„ Image placeholder while fetching the actual image
  • ๐ŸŽฉ New tips on the plugin itself
  • ๐ŸŽฌ Better notification with error handling
  • ๐Ÿชฒ Some small bugs squashed (thanks Zhen Wang)
Trust

Permissions and privacy

Network access

This plugin's manifest doesn't declare its network access, which is common for older plugins. Figma shows a warning on the Community page for plugins like this.

Extra permissions

None beyond the standard access to the file you run it in.

Read from the plugin's published manifest. Questions about data handling go to the developer's support page.

Rankings

Where Spreadsheet Sync ranks

Compare

Spreadsheet Sync alternatives

  1. 1

    Table Creator

    by Gavin McFarland

    795K users6.5KFree

    Easily create tables that can be edited, resized and maintained using your design system

  2. 215K users5.8KFree

    Sync content from Google Sheets directly into your Figma file.

  3. 201K users1.1KFree + $5/mo upgrade

    Generate and customize tables in seconds

  4. 4

    Tablefy

    by Kiko Herrschaft

    184K users245Free
  5. 5

    data.to.design

    by divRIOTS

    40K users1.2KFree

    Design with your data from Google Sheets, CSV, JSON, Airtable, Notion, or generate using AI

  6. 6

    Quick table

    by Carter Xiao

    40K users212Free

    Spreadsheet to table frame in seconds

FAQ

Spreadsheet Sync FAQ

What does Spreadsheet Sync do?

Design smarter: use real data from your spreadsheets in Figma. It's a Figma plugin by Andre Pinto that runs in Figma Design.

Is Spreadsheet Sync free?

Yes. Spreadsheet Sync is free to install and run from the Figma Community, with no paid tier listed.

How do I install Spreadsheet Sync?

Open it on the Figma Community, or search for it in the Actions menu (Cmd/Ctrl + K) inside any file you can edit. See how to install Figma plugins.

What are the best alternatives to Spreadsheet Sync?

By user count, the closest alternatives are Table Creator by Gavin McFarland, Google Sheets Sync and Table Generator & Creator. Compare all of them on the best Figma plugins for tables.

For developers

Built this plugin?

Use this page as a landing page for Spreadsheet Sync: link to it from your site, README or launch posts, or add a badge. Pick a style and copy the code.

Spreadsheet Sync on figmaplugins.co

Style

Label

Size

Code

<a href="https://figmaplugins.co/plugins/spreadsheet-sync/" target="_blank" rel="noopener"><img src="https://figmaplugins.co/badges/featured-dark.svg" alt="Spreadsheet Sync on figmaplugins.co" width="220" height="48"></a>