How to Connect Google Sheets to UniLink (Log Contacts and Orders Automatically)

A step-by-step guide to connecting UniLink to Google Sheets so every new contact, form submission, and order on your page is automatically logged to a spreadsheet in real time.

Most creators and small business owners already live in Google Sheets — it's where the team checks sales, where the accountant grabs order data, and where reporting happens at the end of the month. Connecting UniLink to Google Sheets means that spreadsheet stays current without any manual export or copy-paste. Every contact captured, form submitted, or order completed on your UniLink page lands as a new row in whatever sheet you designate, instantly and automatically. The integration uses Google OAuth, takes about five minutes to configure, and requires no third-party automation tool.

What the Google Sheets Integration Does

UniLink's Google Sheets integration writes new rows to a spreadsheet of your choice whenever a trigger event occurs on your page. The three supported trigger types are new contact (someone added to your UniLink contact list), new order (a completed payment via Stripe or another connected payment processor), and new form submission (a visitor submits a form block on your page). Each event type sends a different set of fields — contact events send name and email, order events send customer email, product name, and amount, and form events send all the fields collected in that specific form block.

The integration connects directly to your Google account via OAuth — there is no intermediary tool like Zapier required. Once authorized, UniLink appears as a connected app in your Google account, and you can revoke access at any time from Google's security settings. Because the connection is direct, rows appear in Google Sheets within seconds of the triggering event, with no polling delay or task queue. This makes the integration reliable for time-sensitive workflows like sales monitoring or lead tracking, where a one-hour lag in a third-party automation platform would be unacceptable.

The column mapping step in UniLink's integration settings lets you specify which UniLink data fields write to which spreadsheet columns. You configure this once per event type. If your spreadsheet already has headers — Email, Name, Date, Amount, Product — you map the UniLink fields to those columns and the integration respects the structure you already have. If you're starting from a blank sheet, UniLink can auto-create headers. The mapping is saved and applied to every subsequent event, so the spreadsheet grows cleanly with consistent columns every time a new row is written.

How to Get Started

1. Open UniLink Integrations: Log in to your UniLink Dashboard at app.unilink.us, navigate to Integrations, and find Google Sheets. Click Connect.
2. Authorize with Google OAuth: A Google sign-in window will open. Sign in with the Google account that owns the spreadsheet you want to write to. Grant UniLink permission to access and edit your Google Sheets. You'll be redirected back to the UniLink Dashboard after authorization completes.
3. Select your spreadsheet and sheet tab: In the Google Sheets integration settings, use the dropdown to select the Google Sheets file you want to log data to. Then select the specific sheet tab (the bottom tab name inside that file) where rows should be written. If the file doesn't exist yet, create it in Google Sheets first, then return here to select it.
4. Choose event type and map columns: Select the trigger event type — new contact, new order, or new form submission. Then map the available UniLink data fields to your spreadsheet columns. For each column in your sheet, choose which UniLink field should populate it. Add a Date/Time column and map the event timestamp for easier reporting.
5. Save and test: Click Save. Use the "Send test row" button in UniLink to write a sample row to your spreadsheet and verify the column mapping is correct. Open your Google Sheet to confirm the test row appeared with data in the right columns. Repeat the setup for additional event types if you want to log contacts, orders, and form submissions to the same or different sheets.

How to Use the Google Sheets Integration

1. Log all new contacts to a master contact sheet: Map the new contact event to a sheet with columns for Email, Name, and Date Added. Share that sheet with your team or virtual assistant so they always have access to the latest contact list without needing a UniLink login.
2. Build a live sales log: Map the new order event to a separate sheet with columns for Date, Customer Email, Product Name, and Amount. Add a SUM formula to a totals row at the top of the sheet to get a running revenue figure that updates every time a new order row is written.
3. Capture form responses for review: Map a specific form block's submission event to a sheet with one column per form field. This creates a spreadsheet version of your form responses, useful for forms that collect application data, event RSVPs, or survey answers that need manual review.
4. Feed data into Google Data Studio or Looker Studio: Use your UniLink-connected Google Sheet as a data source for a Looker Studio dashboard. Because the sheet is always current, the dashboard reflects real-time UniLink activity with no manual refresh required.
5. Share filtered views with collaborators: Use Google Sheets' filter views to give team members or clients a view of the data relevant to them — an accountant sees only order data, a community manager sees only contact additions — without exposing your entire spreadsheet or your UniLink account.

Key Settings

Get the Most Out Of Google Sheets

Use conditional formatting in your Google Sheet to highlight high-value orders as soon as they appear. Set a rule that turns a row green if the Amount column exceeds a threshold — for example, orders over $100. Because UniLink writes the row automatically, the formatting triggers the moment the order lands, giving you an at-a-glance view of large purchases in your live sales log without having to scan the whole sheet.

Connect your UniLink Google Sheet to a second sheet for automated reporting. In a separate "Reports" tab, use COUNTIF and SUMIF formulas referencing the raw data tabs to build summary metrics: total contacts this month, total revenue, top product by order count. Because the raw tabs are continuously updated by UniLink, the summary formulas always reflect current data. Share the Reports tab with stakeholders who need the numbers but don't need to see individual customer rows.

Set up Google Sheets email notifications to alert you when new rows are added. In Google Sheets, go to Tools → Notification Rules and select "Any changes are made." This sends you an email whenever UniLink writes a new row — effectively giving you email alerts for new contacts and orders without needing a separate notification tool. It's a useful fallback for monitoring activity when you're not actively checking the spreadsheet.

Archive your UniLink data monthly to prevent the sheet from growing unwieldy. At the start of each month, copy the data rows from the previous month to an archive tab labeled by month and year, then clear the main data tab. This keeps the active logging tabs fast to scroll and filter, while preserving historical data in clearly labeled archive tabs within the same file. Running total formulas in your Reports tab can reference both current and archive tabs so historical reporting stays intact.

Troubleshooting

Frequently Asked Questions