If you create one sheet,
You can use that information around.

Hanai Akihiro

Design

How to use Figma’s plugin “Google sheets sync”|Let’s reflect the information compiled in the spushi to the design in a batch.

Post:2024.03.18 / Rewrite : 2024.03.18

View

194 views

For example, when designing a blog, it is difficult to manually input the blog "title," "eye-catching image," and "excerpt text" every time you are designing a blog. In such cases, the Google sheets sync plugin, which allows you to reflect information compiled in Google spreadsheets in your design in a batch, is useful.

figma-plugin-google-sheet-sync

Watch the video on how to use the plugin “Google sheets sync”.

How to use the “Google sheets sync” plugin

figma-plugin-google-sheet-sync

1. Prepare the Google Spreadsheet you wish to reflect.
Pay attention to the first line. Make this title, img, text part the same as the layer name in Figma.

If you are using an image, specify the URL of the image in the Google Spreadsheet value; the URL must end in .jpg, .png, or .gif.

Here, we specify the URL of the dummy image generator site (https://placehold.jp/).

2. Once entered, go to “Share” and set the general access to “Everyone who knows the link”.

3. Next, create the main component in Figma and place an instance on the design.

The layer name is important, and as I told you earlier, it should be the same name as the first line of the Google Spreadsheet, with the “#” in the beginning.

You are now ready to go.

4. With the layer you want to insert data into selected, go to Resources, search for and launch the Google sheets sync plugin.

5. After entering the URL of the spreadsheet, click “Fetch & Sync.
The information is now entered.

6. If the image does not fit, the last part of the URL you entered in the spreadsheet will be “.jpg”, “.jpg”, “.jpg”, “.jpg”, or “.jpg”,

Contact

Contact me

I want to convey this kind of thing!
I want to express something like this!
I'm thinking about this kind of time frame and budget... 🤔
First of all, please let me know your frank requests.
I will respond with sincerity.

contact
tel tel