Data entry is being done on the Comparison DATA ENTRY Sheet tab. Please DO NOT add or delete columns to this sheet unless at the far right. Doing so will throw off all the other sheets.
Once you've filled in the data on the DATA ENTRY tab, switch over to the FIGMA_DATA-Focus-Sync tab. This is the data represented for Figma consumption.
For your entries you wish to graph, make sure that
there is logo image in the "Logo" row (3), and that the data in the cell is a URL that ends in either .png or .jpg. If it's anything else then the plugin we are using will go into an endless read loop.
The "Competitor" row (2) has the proper name in it. This is the name as it will appear in the infographic. Make sure it has proper capitalization, spacing, etc. If you are doing a lot of them you can copy down from row 1, then run a title-case add-on, and find/replace to ditch "-"s' and "_"s'.
Your data is now ready to go. For each competitor you wish to generate a graph for, copy from the "Competitor" row (2) down to the end of the column of data (currently row 110), and then. . . .
Make a copy of the file into your local Figma workspace
In this file, there are pages on the left. Right click on the page GitLab vs. Competitor Template, v2.
Select to "Duplicate Page".
Immediately rename the new page so thing don't get confusing. (I use "Run X" and increment X)
On the new page
Go to the lower left pane and find the object named "competitor-vs-gitlab". Unlock it (icon on the right).
Make as many copies of the whole infograph (the "competitor-vs-gitlab" object) as you need. hint there are two pre-setup templates (pages) you can start with instead, with 6 and 12 infographs)
Your Figma file is ready to import into
Install the plugin
This all works via an amazing Figma plugin called Google Sheets Sync. <——– Click on this link from your browser session also logged into FIgma to install it into your Figma instance.
That's that. Not so hard huh?
Run the autogen
Make sure in Figma you are showing the page you want to generate with
Go to the Figma "hamburger" menu (top left, 3 parallel horizontal lines)
Select "Plugins" => "Google Sheets Sync"
In the dialog that pops up, where it says "Enter Sheets shareable link here", paste the URL of your stage file (created earlier). reminder this file needs to be world readable.
Set the pulldown selection to Update current selection only
Click on the "Fetch & sync" button.
Watch the magic happen . . .
You might need to tweak the logo sizes and Competitor name a little in the header area, based on the input sizes of those items.
Get and use the results
Export the resiults
Once the infograph is generated, go back to the left pannel and change each object name ("competitor-vs-gitlab") to reflect the competitor name on that infograph (click on it in the left pannel and see which infograph gets selected).
Make sure nothing is selected (click on the background)
Go to the "hamburger" menu
Select "File" => "Export"
In the box that pops up, select only the "competitor-vs-gitlab" images
Click the "Export" button and save the file somewhere on your hard drive.
Use the results
Unzip the file to get the folder of all exported images
The resulting images are too big for our comparison page purposes, so we'll resize them
On Mac, open a Terminal and go into the folder
In the terminal run the command sips -Z 1081 *.jpg
This will convert each file to 1081x1080 (LxW)
Upload the images to wherever you need them to be used