Google Sheets

Google sheets is a fantastic tool for preparing your data for the Webflow CMS. It's easy to use, free, and highly capable.

Just as important, your client can access it to complete and review data work before you do the load.

Useful Functions

These are some of the functions and techniques worth knowing about;

Named Ranges

Name ranges for reference and administration. Ranges can be open-ended with e.g. _{Team = A2:A}

COUNTA

Determine the number of populated cells in a table

_{COUNTA(Team) = 223}

SEQUENCE

The SEQUENCE function allows you to generate numeric sequences.

• Generate integer sequences for explicitly sorted data. Here I recommend organizing your data the way you want, and then generate an integer sequence with a step of 10. That makes it easy for your client to insert new items later with minimal collision.
• Demonstration data. If you need to show 100 items and identify them as they shift and move about the page, this is an ideal way to numerically identify them.

RANDOM SELECTION

Random Selection from a List, a technique outlined by Kieran Dixon here.

_{=index(Team, RANDBETWEEN(1,COUNTA(Team)))}

‍

‍

Internal Resources

e.g.

https://docs.google.com/spreadsheets/d/1zKSd2hxTz-F0a8U6LxsTPicAZGoeQq05PAJkHXm-fKc/edit#gid=348733693

‍

‍