Home / Agencies
For marketing and e-commerce agencies

Every client's Shopify, HubSpot and ad numbers, in a deck

Connect a client's Shopify, HubSpot and ad accounts to Quiriz directly, or point it at the Google Sheet or Excel file a connector tool already fills. Either way it refreshes daily, and you ask for the answer, the table or the whole PowerPoint deck.

Sign up free → Or ask the sample HubSpot data first. No signup needed.

The monthly client report is the same work every month: export, paste, rebuild the charts, write the commentary. A connection or a connector tool takes care of the export. Quiriz takes care of the rest, with the same metric definitions for every client and every month.

How it works

There are two routes into Quiriz, and you can mix them within one client. Connect directly where Quiriz has a connector: Shopify, HubSpot, Google Ads, Meta Ads, Google Analytics 4, Search Console, Klaviyo, Stripe, QuickBooks, Harvest, PostHog and Bing Webmaster Tools. Each connection is read-only, refreshed daily and included on paid plans, and someone with access to the client's account signs in once to approve it. Each connection reads one account, store, property or site, so a client with two ad accounts needs two connections. Use a spreadsheet for any source without a connector, or when a client will not grant sign-in access. A connector tool writes the data to a Google Sheet or Excel workbook, and Quiriz reads that. The steps below are for the spreadsheet route.

  1. A connector tool writes the client's data to a spreadsheet. A Google Sheet or an Excel workbook on OneDrive, one per client, one tab per source, refreshed every morning.
  2. Quiriz reads each tab as a dataset. You connect the file once.
  3. Quiriz refreshes the datasets daily. It picks up whatever the connector wrote overnight.
  4. You ask. A number, a table and chart in Excel or Sheets, a PowerPoint or Google Slides deck, or a Word report. ROAS, win rate and net sales mean the same thing in every one, because you define them once in Company Context.

What connecting your sources adds

Once a client's sources are connected, Quiriz can answer across them, joined on a shared date, a mapping you supply, or a name you keep consistent. Connections belong to the workspace they are made in, so a client kept in its own workspace gets its own set. The questions below are the kind a client report keeps asking and a single export cannot answer.

Cross-source figures are not pre-defined metrics. Each answer states whether it came from a stored definition or was answered freehand, and a figure you report every month is worth defining once in Company Context.

Connector tools that write to Google Sheets or Excel

Use these for sources Quiriz does not connect to directly, or when a client will not grant sign-in access. Each of these covers Shopify, HubSpot, Google Ads and Meta Ads and refreshes a spreadsheet on a schedule. Prices are the lowest plan that includes scheduled refresh.

ToolStarting priceWhat it includesGoogle SheetsExcel on OneDriveFree plan or trial
API Connector$15/mo ($12 annually)2,500 requests a month. You set up the API requests yourself.DailyNoFree plan (no schedule)
Adveronix$29/mo5 ad accounts, 5 saved reports. No-code setup.Daily or hourlyNo2-week trial
Porter Metrics$15/mo for 1 account$40 for 4 accounts, $8 per account for 5–12, $100 for 13–20DailyNo14-day trial
Catchr$24/mo3 platforms, 10 accountsDailyNo14-day trial
Windsor.ai$23/mo ($19 annually)3 sources. All four sources from $118/mo ($99 annually), 75 accountsDaily, even on FreeManual refresh onlyFree plan (1 source, 1 account), 30-day trial
Dataslayer€20/mo billed annually3 sources, 3 accounts each. 7 sources and 50 accounts at €99/moDailyScheduledFree plan (1 source, manual refresh)
Supermetrics$55/mo ($44 annually)3 sources, 3 accounts per source, 1 userCheck the planScheduled14-day trial
SkyviaFree, then $79/mo billed annuallyFree plan runs once a day, up to 10,000 records a monthDailyAdds rows onlyFree plan

List prices in USD (Dataslayer in EUR), checked October 2026. Vendors change plans often, so confirm on their pricing page before you buy. "Scheduled" in the Excel column means the tool refreshes a workbook saved in OneDrive or SharePoint without anyone opening it.

Not a fit for this setup: automation tools that add one row per event, such as a new order, cannot pull an ad report into a spreadsheet. Tools that deliver only to a data warehouse need that warehouse first.

Which one to pick: API Connector is cheapest if you can set up API requests, Adveronix if you would rather click through a form. Porter Metrics suits one to three clients, Windsor.ai past about ten. For Excel, Dataslayer or Supermetrics refresh a workbook on OneDrive; to start free, Skyvia refreshes a Google Sheet once a day.

Setting up the spreadsheet route

Four settings matter most: one file per client with one tab per source, a fixed start date, Replace rather than Append, and columns that stay stable. The full steps are below.

Set up the connector

Set up the connector

The steps differ a little by tool, but these settings are what make the data come out right in Quiriz:

  1. One file per client, one tab per source. For example, a "Northwind" Sheet or workbook with tabs for Shopify orders, HubSpot deals, Google Ads and Meta Ads. For Excel, save the workbook in OneDrive.
  2. Pick a fixed start date, such as January 1, 2024, rather than "last 30 days". Quiriz replaces the dataset on every refresh, so the file should hold the full history you want to ask about.
  3. Choose Replace (sometimes called overwrite), not Append. Ad platforms restate recent days as conversions come in, and HubSpot deals change stage. Append turns each change into a second row, and totals get counted twice.
  4. Pull daily rows by campaign for ads, and one row per order or deal for Shopify and HubSpot. Include the IDs (campaign ID, order ID, deal ID) as well as the names.
  5. Schedule the refresh for early morning, before the Quiriz refresh window you pick below.
  6. Keep the columns stable. Adding a column later is fine. Renaming or removing one stops the Quiriz refresh until it's restored.
Connect a Google Sheet and turn on its daily refresh

Connect a Google Sheet in Quiriz

  1. Open Import Data from the side navigation and click Google Drive.
  2. Give Quiriz view access to the Sheet. Either share it as a Viewer with the address shown under the box (data@quiriz.co), or click Connect Google if that option appears.
  3. Paste the Sheet's URL and click Load.
  4. Under Select Sheets, pick the tabs to import, then click Convert.
  5. Click Upload as Dataset, or Upload All for several tabs. Each tab becomes its own dataset, already linked to the Sheet.

Turn on the daily refresh for a Google Sheet

  1. Open Manage Data, select the dataset, and click Schedule Data Refresh.
  2. File Source is already set to Google Sheet, with the Sheet filled in.
  3. Set Refresh mode to By file ID.
  4. Set Check frequency to Daily and pick a time window, such as Morning (6am–12pm). Quiriz uses the timezone in My Preferences.
  5. Click Save Schedule, then Run Now to test it. The result shows under Ingestion History.

Repeat for each tab's dataset. Every report and deck built on these datasets reads the refreshed numbers on its next run.

Connect an Excel workbook on OneDrive

Connect an Excel workbook on OneDrive

  1. Open Import Data and click OneDrive. If you see Connect Microsoft, click it and sign in with the Microsoft account that holds the workbook.
  2. In your browser, open the OneDrive folder that holds the workbook and copy the address bar link (it starts with https://onedrive.live.com/?id=).
  3. Paste it and click Load. Tick the workbook in the file list, then click Import 1 file.
  4. When the import finishes, click Schedule refresh on the "Set up scheduled refresh for these files?" banner.
  5. Set the workbook to Refresh the same updated file, choose Daily and a time window, and click Save.

Quiriz checks the workbook at that time each day and refreshes the datasets when the connector has updated it. To change the schedule later, or to run it right away, use Schedule Data Refresh on Manage Data.

Scheduled refresh is included from the Plus plan. On Free, use Run Now from Schedule Data Refresh.

Common problems

One report setup, every client

The monthly client report is the same structure for every client and different data for each. Quiriz keeps each client in its own project, with its own datasets, questions, reports and people, so the structure is set up once and run per client.

Make a deck: three prompts to try

Open the client's project, tick its datasets, and paste one of these with the client's name and month. Quiriz plans the slides first, so any title or question can be edited before it builds. In PowerPoint each chart and table carries two to four takeaways written from that slide's own figures; Slides closes with an executive summary.

E-commerce client, monthly report

PowerPoint, Consulting style. Tick the client's Shopify, Google Ads and Meta Ads datasets.

"Monthly report for our client [client] for August 2026. Net sales, orders and average order value against July and against August 2025, net sales by category, ad spend and ROAS by platform for August, ROAS by platform by month this year, and the campaigns with the highest and lowest ROAS in August. End with recommendations."

What comes back, about nine slides:

  1. Agenda and executive summary.
  2. The headline numbers against last month and last year, as a table.
  3. Net sales by category: a bar chart.
  4. Spend and ROAS by platform: a table for the month.
  5. ROAS by platform by month: a line chart.
  6. Best and worst campaigns: a table.
  7. Recommendations, written from those slides.

SaaS client, monthly report

Google Slides. Tick the client's analytics, ad, product analytics and Stripe datasets.

"Monthly report for our client [client] for October 2026. Signups by channel against September, paid spend and cost per signup by platform, October campaigns by cost per signup, organic search clicks by month, and MRR by month this year."

What comes back: signups by channel, a table of spend and cost per signup by platform, campaigns ranked by cost per signup, organic clicks by month, and MRR by month, then the executive summary.

Quarterly business review for a client

PowerPoint, Consulting style. Tick every dataset in the client's project.

"Quarterly business review for our client [client] for 2026 to date against the same period of 2025. Net sales and orders for both periods, net sales by month, refund rate by quarter, Facebook and Google spend and ROAS by quarter, wholesale win rate and won revenue for both periods, and win rate by region. End with recommendations for the fourth quarter."

What comes back: about ten slides, from the year-to-date comparison through sales, refunds, paid media and pipeline, closing with Recommendations for the next quarter written from what those slides found. Drop the pipeline lines for a client without a CRM.

Sign up free → Connect one client's file and check the numbers against last month's report.

Pricing

You pay for workspaces and the people who build them, not for everyone who asks a question. Connectors are included on paid plans, and scheduled spreadsheet refresh is included from the Plus plan. See pricing →

Your data stays yours, and we do not train on it. Privacy policy →

Related reading

Questions

Which connector tool should an agency start with?
For the lowest cost, API Connector starts at $15 a month if you are comfortable setting up API requests, and Adveronix starts at $29 a month with no-code setup. For one to three clients, Porter Metrics prices per connected account. Past about ten clients, Windsor.ai pools 75 accounts across sources. Any tool that writes to Google Sheets or an Excel workbook on OneDrive on a daily schedule works with Quiriz.
Can I use Excel instead of Google Sheets?
Yes. Use a connector tool that refreshes an Excel workbook saved in OneDrive on a schedule, such as Dataslayer or Supermetrics. Import the workbook into Quiriz from OneDrive and choose Refresh the same updated file, and Quiriz picks up each day's changes.
Should the connector use Replace or Append mode?
Replace. Ad platforms restate recent days as conversions come in, and a HubSpot deal changes stage after it is first written. In Append mode both become a second row and totals are counted twice. Replace over a fixed start date keeps one current row per record.
How often does Quiriz refresh the data?
Connected sources refresh daily. Spreadsheet and file sources refresh daily, weekly or monthly, in a time window you choose, in your own timezone. Run Now refreshes it on demand. Scheduled refresh is included from the Plus plan.
Can I run the same client deck for every client?
Yes. Keep each client in its own project with its own datasets. In Quiriz for PowerPoint or Google Slides, open the client's project, tick its datasets and describe the deck with that client's name and month; Quiriz plans the slides for you to edit before it builds. To keep one agency template, type =QUIRIZ.ASK() markers on its slides and press Build from markers for each client.
Does Quiriz need access to my clients' ad or store accounts?
Only if you connect directly. Then someone with access to the client's account signs in once and approves read-only access. If you use a connector tool and a spreadsheet instead, the tool holds those connections and Quiriz only needs view access to the Google Sheet or Excel workbook it writes to.
Should I connect a client's accounts directly or use a connector tool and a spreadsheet?
Connect directly where Quiriz has a connector: Shopify, HubSpot, Google Ads, Meta Ads, Google Analytics 4, Search Console, Klaviyo, Stripe, QuickBooks, Harvest, PostHog and Bing Webmaster Tools. Connections are read-only, refreshed daily and included on paid plans. Use a connector tool and a spreadsheet for any source without a connector, or if a client will not grant sign-in access.