Connecting Your Spreadsheet Data To Spinify For Competitions & Metrics
Do you track sales or performance data in Google Sheets or Excel? Great news — you can easily turn that raw data into dynamic Spinify competitions or personal metrics visible on your team dashboards and TVs. Here's how to get your spreadsheet ready for integration with Spinify.
TLDR:
📊 Step-by-Step: Prepare Your Spreadsheet
You can copy and use our template as a guide.
1. Structure Your Data Clearly
Start with a spreadsheet that contains the following columns:
-
Email – used to map data to Spinify users.
-
Sale Amount – numeric value for each sale.
-
Date – the date the sale was made.
-
Type of Sale – category or classification of the sale.
2. Create a Pivot Table for Summarization
A pivot table helps summarize your data in a way that can easily map to Spinify metrics or competition data.
Pivot Table Setup:
-
Rows: Use
Emailso each row represents an individual. -
Values: Add both:
-
Sum of Sale Amount– for total sales values. -
Count of Sales– for number of sales made.
-
-
Filters: Add filters to narrow down by:
-
Date(e.g., this year) -
Type of Sale(e.g., new vs renewal) -
Or any other custom field relevant to your goals.
-
💡 Tip: You can create multiple pivot tables to track different metrics like monthly performance or specific sale types.
📅 Suggested Date Filters (for Google Sheets)
To track metrics based on specific timeframes, use these filter formulas in your sheet. Replace Date with your actual column name if it differs.
| Timeframe | Formula |
|---|---|
| Today | =AND(DAY(Date)=DAY(TODAY()), MONTH(Date)=MONTH(TODAY()), YEAR(Date)=YEAR(TODAY())) |
| This Week | =AND(WEEKNUM(Date)=WEEKNUM(TODAY()), YEAR(Date)=YEAR(TODAY())) |
| This Month | =AND(MONTH(Date)=MONTH(TODAY()), YEAR(Date)=YEAR(TODAY())) |
| This Year | =YEAR(Date)=YEAR(TODAY()) |
These filters help refine which rows are included in each metric or challenge, making it easy to run time-based competitions like "Top Sellers This Month".
🏆 Ready to Launch Your Competition
Once your pivot table is ready and filtered for the desired timeframe or sales type:
-
Sync it with Spinify.
-
Choose whether to link it to a Competition or a Personal Metric.
-
Set a goal and watch your leaderboard come to life!
You're in full control of the KPIs you want to display. Whether you're aiming to boost deal count, total revenue, or specific campaign goals — Spinify keeps your team aligned and motivated.