Remote teams need a reliable way to collect data, approve requests and keep everyone in sync. Tally provides a no‑code platform that stores answers directly in Google Sheets. This guide walks you through the concepts, setup steps, core workflows, advanced patterns and the most common mistakes to avoid.
Tally is a form builder that writes each submission to a Google Sheet row. Think of it as a bridge between a web form and a spreadsheet. The bridge has three parts:
Because the data lives in Sheets, any team member with edit access can create charts, run filters, or add formulas. No separate database is required.
Go to tally.so and sign up with a Google or GitHub account. Choose “Team” during onboarding to enable shared access.
In the dashboard, click Settings → Integrations → Google Sheets. Authorize the same Google account that stores your team’s master spreadsheet. Pick the file and the worksheet where you want data saved.
Give every remote teammate “Editor” rights on the selected spreadsheet. In Tally, under Team Settings, set the role to “Can edit forms”. This prevents accidental read‑only blocks.
Create a simple “Ping” form with one text field. Enable “Save to Google Sheets”, submit a test entry, and verify that a new row appears. If the row is missing, revisit the integration toggle and re‑authorize.
Collect updates from every member every Friday.
| Step | Action | Details |
|---|---|---|
| 1 | Form | Fields: Name, Project, Blockers, Next Steps (max 200 chars) |
| 2 | Save to Sheets | Worksheet: weekly_status |
| 3 | Send confirmation to submitter | |
| 4 | Slack | Post a summary to #team‑updates channel |
Remote teams often need a quick approval loop for receipts.
| Step | Action | Details |
|---|---|---|
| 1 | Form | Upload receipt, amount, description, approver email |
| 2 | Save to Sheets | Worksheet: expenses |
| 3 | Assign | Email to approver with “Approve” / “Reject” buttons |
| 4 | Conditional | If approved → mark “Paid” column, send receipt to finance; else notify submitter |
New hires fill a form that triggers tasks in Asana.
onboarding tab.Use the “Assign to” action with a formula like {{ manager_email }}. The manager field can be pulled from a separate “Team Directory” sheet using VLOOKUP. This ensures the request always lands with the right person, even after role changes.
Add a “Delay” step set to 48h. Pair it with a custom script in the sheet that calculates the recipient’s local time (store timezone_offset column). The reminder email includes the local time to reduce missed approvals.
Before a row is considered “final”, add a column Valid? with a formula:=AND(ISNUMBER(B2), LEN(C2)>5, NOT(ISERROR(VLOOKUP(D2,Managers!A:B,2,FALSE)))). In Tally, use a “Conditional” step that only proceeds if {Valid?}=TRUE. This catches typos early.
Install the free “Sheet2Site” add‑on, then create a script that runs daily, converts each new row into a PDF, and stores it in a shared Drive folder. Link the PDF URL back to the original Tally entry for traceability.
_date or _amount.COUNTIF.Tally is a no‑code form and workflow builder. It stores data in Google Sheets, so remote teams can collect, review and act on information without writing code.
In the Tally dashboard, open Settings → Integrations → Google Sheets. Authorize the account, pick a spreadsheet, and map each form field to a column.
Yes. Use the “Assign to” action with a dynamic email field. Add a “Reminder” step that triggers after 48 hours, ensuring the right person receives the request wherever they are.
Skipping the “Test submission” step, using duplicate column names in Google Sheets, and disabling the “Save to Google Sheets” toggle are the top three reasons for lost data.
Tally’s free plan includes unlimited forms, up to 100 submissions per month, and Google Sheets integration. Paid plans start at $12 per month for higher limits and premium support.
Remote teams can now use Tally to streamline reporting, approvals and onboarding. Follow the steps, avoid the pitfalls, and your data will stay organized across time zones.