Gsheet

Manipulate and Style Google Spreadsheet Data for RapidWeaver Like Magic!

Examples
Stacks Image 1287
assistant
Example #1

Quick Tutorial

Your Google Spreadsheet must be divided into titled columns like so:

Data can be grabbed using double curly braces {{ }} like so:

{{row.followers}}

⬇︎

1000, 1200, 5000 . . .

Gsheet will take whatever content placed inside, and
duplicate it for each row in your spreadsheet.

You can simply grab the value for the corresponding row by typing:
{{row.attribute}} or {{row.multiword_value}}

Column titles MUST start with a letter.
Values like {{row.2019}} or {{row.2019_year}} will NOT work

TRY IT OUT! 👉

{{row.name}}
{{row.address}}
verified_user
Property is {{row.status}}
error
Property is {{row.status}}
remove_circle
Property is {{row.status}}
block
Property is {{row.status}}
{{row.beds}}
Beds
{{row.baths}}
Baths
{{row.square_feet}}
Square ft.
{{row.year_built}}
Year
cloud_done
Corresponding Sheet
assistant
Example #2

Quick Tutorial

Your Google Spreadsheet must be divided into titled columns like so:

Data can be grabbed using double curly braces {{ }} like so:

{{row.followers}}

⬇︎

1000, 1200, 5000 . . .

Gsheet will take whatever content placed inside, and
duplicate it for each row in your spreadsheet.

You can simply grab the value for the corresponding row by typing:
{{row.attribute}} or {{row.multiword_value}}

Column titles MUST start with a letter.
Values like {{row.2019}} or {{row.2019_year}} will NOT work

TRY IT OUT! 👉

LEVEL
{{row.level}}
Advanced
Intermediate
{{row.name}}
FOCUS:
{{row.focus}}
Advanced
Intermediate
bar_chart
{{row.focus}}
Text Here
MEMORY:
{{row.memory}}
Advanced
Intermediate
bar_chart
{{row.memory}}
Text Here
LANGUAGE:
{{row.language}}
Advanced
Intermediate
bar_chart
{{row.language}}
Text Here
PROBLEM SOLVING:
{{row.problem_solving}}
Advanced
Intermediate
bar_chart
{{row.problem_solving}}
Text Here
LOGICAL REASONING:
{{row.logical_reasoning}}
Advanced
Intermediate
bar_chart
{{row.logical_reasoning}}
Text Here
cloud_done
Corresponding Sheet
assistant
Example #3

Quick Tutorial

Your Google Spreadsheet must be divided into titled columns like so:

Data can be grabbed using double curly braces {{ }} like so:

{{row.followers}}

⬇︎

1000, 1200, 5000 . . .

Gsheet will take whatever content placed inside, and
duplicate it for each row in your spreadsheet.

You can simply grab the value for the corresponding row by typing:
{{row.attribute}} or {{row.multiword_value}}

Column titles MUST start with a letter.
Values like {{row.2019}} or {{row.2019_year}} will NOT work

TRY IT OUT! 👉

{{index}}
{{row.title}}
INACTIVE
Holdings ∨
Industries ∨
Year 1
{{row.year_1}}
Year 3
{{row.year_3}}
Year 5
{{row.year_5}}
Cost
{{row.cost}}
{{row.risk}} risk
{{row.risk}} risk
{{row.risk}} risk
cloud_done
Corresponding Sheet
assistant
Example #4
Conditional Content & Styles
Gsheet comes with an amazing Gshet IF stack which allows you to set conditional content and styles based on values in your spreadsheet! This makes Gsheet extremely powerful and useful~
Notice how the spots left section turns red if the value is less than 6!
cloud_done
Corresponding Sheet

Quick Tutorial

Your Google Spreadsheet must be divided into titled columns like so:

Data can be grabbed using double curly braces {{ }} like so:

{{row.followers}}

⬇︎

1000, 1200, 5000 . . .

Gsheet will take whatever content placed inside, and
duplicate it for each row in your spreadsheet.

You can simply grab the value for the corresponding row by typing:
{{row.attribute}} or {{row.multiword_value}}

Column titles MUST start with a letter.
Values like {{row.2019}} or {{row.2019_year}} will NOT work

TRY IT OUT! 👉

star
{{row.class}}
{{row.start}} – {{row.end}}
{{row.instructor}}
{{row.rating}}
{{row.spots_left}}
SPOTS LEFT
assistant
Example #5
Use Gsheet as a basic CMS to display simple content like this!

Quick Tutorial

Your Google Spreadsheet must be divided into titled columns like so:

Data can be grabbed using double curly braces {{ }} like so:

{{row.followers}}

⬇︎

1000, 1200, 5000 . . .

Gsheet will take whatever content placed inside, and
duplicate it for each row in your spreadsheet.

You can simply grab the value for the corresponding row by typing:
{{row.attribute}} or {{row.multiword_value}}

Column titles MUST start with a letter.
Values like {{row.2019}} or {{row.2019_year}} will NOT work

TRY IT OUT! 👉

{{row.title}}
{{row.description}}
– {{row.author}}
Stacks Image 1216
cloud_done
Corresponding Sheet
assistant
Example #6

Quick Tutorial

Your Google Spreadsheet must be divided into titled columns like so:

Data can be grabbed using double curly braces {{ }} like so:

{{row.followers}}

⬇︎

1000, 1200, 5000 . . .

Gsheet will take whatever content placed inside, and
duplicate it for each row in your spreadsheet.

You can simply grab the value for the corresponding row by typing:
{{row.attribute}} or {{row.multiword_value}}

Column titles MUST start with a letter.
Values like {{row.2019}} or {{row.2019_year}} will NOT work

TRY IT OUT! 👉

{{row.metric}}
Hypothesis
{{row.difference}}
{{row.metric}}
Hypothesis
{{row.hypothesis}}
Actual
{{row.actual}}
Difference
{{row.difference}}
{{row.difference}}
{{row.difference}}
{{row.difference}}
{{row.difference}}
cloud_done
Corresponding Sheet
assistant
Example #7
Check out our plans
account_balance

Quick Tutorial

Your Google Spreadsheet must be divided into titled columns like so:

Data can be grabbed using double curly braces {{ }} like so:

{{row.followers}}

⬇︎

1000, 1200, 5000 . . .

Gsheet will take whatever content placed inside, and
duplicate it for each row in your spreadsheet.

You can simply grab the value for the corresponding row by typing:
{{row.attribute}} or {{row.multiword_value}}

Column titles MUST start with a letter.
Values like {{row.2019}} or {{row.2019_year}} will NOT work

TRY IT OUT! 👉

{{row.plan}}
{{row.description}}
{{row.price}}
/month
{{row.projects}}
Projects
{{row.history}}
Day history
{{row.storage}}
Gigabytes
{{row.viewers}}
Viewers
check
close
Private
check
close
Teams
cloud_done
Corresponding Sheet
assistant
Example #8
MONTHLY SALES IN USD
2018
2019

Quick Tutorial

Your Google Spreadsheet must be divided into titled columns like so:

Data can be grabbed using double curly braces {{ }} like so:

{{row.followers}}

⬇︎

1000, 1200, 5000 . . .

Gsheet will take whatever content placed inside, and
duplicate it for each row in your spreadsheet.

You can simply grab the value for the corresponding row by typing:
{{row.attribute}} or {{row.multiword_value}}

Column titles MUST start with a letter.
Values like {{row.2019}} or {{row.2019_year}} will NOT work

TRY IT OUT! 👉

{{row.year_2019}}
Text Here
{{row.year_2018}}
Text Here
{{row.month}}
cloud_done
Corresponding Sheet
assistant
Example #9

Quick Tutorial

Your Google Spreadsheet must be divided into titled columns like so:

Data can be grabbed using double curly braces {{ }} like so:

{{row.followers}}

⬇︎

1000, 1200, 5000 . . .

Gsheet will take whatever content placed inside, and
duplicate it for each row in your spreadsheet.

You can simply grab the value for the corresponding row by typing:
{{row.attribute}} or {{row.multiword_value}}

Column titles MUST start with a letter.
Values like {{row.2019}} or {{row.2019_year}} will NOT work

TRY IT OUT! 👉

star
music_note
{{row.title}}
{{row.artist}}
{{row.time}}
cloud_done
Corresponding Sheet