Google Sheets Reporting

Frequently Asked Questions

• How do I connect my Google Sheets account to Swydo?

  From your client page in Swydo, open the Data Sources tab and click New Data Source, then choose Google Sheets. For most platforms you’ll authorize via OAuth; a few (Klaviyo, CallRail, Call Tracking Metrics, ActiveCampaign) use an API key instead. Once authorized, pick the specific account, property, or page you want to report on. Each one becomes a data source you can drop into any report.

• Can I combine Google Sheets data with other platforms in one report?

  Yes. Every Swydo report supports widgets and KPIs from multiple data sources side by side, so a single report can pull from Google Sheets, Google Ads, GA4, Meta, and more. For paid-media platforms you can also blend up to five sources inside a single widget — useful for cross-channel ROAS, total spend, or unified conversion tables. Custom blended widgets aren’t available for non-ad platforms, but reports themselves can mix anything.

• Is my Google Sheets data secure in Swydo?

  Yes. Swydo connects via OAuth or scoped API keys, encrypts data in transit over HTTPS, and stores access tokens with role-based controls. Swydo is GDPR-compliant and acts as a data sub-processor under a standard DPA. You can revoke any connection at any time, and on account closure all data and credentials are deleted within 90 days. Full details live on Swydo’s privacy and data-storage pages.

• What does Swydo cost, and is there a free trial?

  Swydo offers a 14-day free trial with no credit card required. Pricing is based on the number of data sources, not on users (seats are unlimited) or report volume. The flat plan includes 10 data sources, with a per-source rate beyond that which decreases as you scale. Frequency of reporting doesn’t affect cost. Use the calculator at swydo.com/pricing for an exact quote.

• What's the right way to format a Google Sheet so Swydo reads it cleanly?

  Four rules: (1) the first row must be field/column names — these become your metric and dimension names, and they must all be unique; (2) no merged cells anywhere; (3) numeric columns must be Number-formatted in Sheets, currency columns must be Currency-formatted, percentages must be Percent-formatted, dates must be Date-formatted; (4) one sheet per dataset, no blank rows in the middle. If you change column names later, refresh the schema from the data-source three-dot menu.

• Can I use Google Sheets to bring data into Swydo from platforms it doesn't natively integrate with?

  Yes — this is one of Sheets’ main use cases for agencies. Pipe data from any third-party platform (a CRM, a niche ad platform, a custom database) into a Google Sheet via Zapier, Make, n8n, or a manual export. Connect that sheet to Swydo and use it like any other data source — build widgets, KPIs, blend it with native integrations in the same report. The Sheet becomes your bridge for “any platform Swydo doesn’t have a native integration for.”

• How do I set up date filtering for a Google Sheets data source?

  When you add a Google Sheets widget, Swydo asks you to pick a “Date range field” — the column it should filter on. Only Date-formatted columns are valid options. If your sheet doesn’t have a date column (e.g., a static lookup table), choose “No date range” and the widget will use all rows regardless of report-level date range. For time-series reporting, ensure your date column is real Date type, not text.

• Can multiple people on my team add data to the same Google Sheet that feeds Swydo?

  Yes. The Sheet itself is a normal Google Sheet with whatever sharing permissions you configure in Drive. The Swydo connection just reads from it, so anyone with edit access in Google can update the data — Swydo will pick up changes on the next data refresh. Useful for agencies where account managers update offline KPIs (e.g., manual conversion data, client-reported metrics) that the Sheet then feeds into automated reports.

• My Google Sheet has new columns but Swydo isn't seeing them. How do I refresh?

  Open the data source list (in the client’s Data Sources tab), hover over the affected Google Sheets connection, click the three-dot menu, and select Refresh fields. Swydo will re-read the column headers and surface any new columns as available metrics or dimensions. Do this any time you add, rename, or restructure columns in the underlying sheet.

• Are there limits on how many rows a Google Sheet can have for Swydo reporting?

  Google Sheets itself supports up to 10 million cells per workbook, and Swydo can handle large sheets, but performance degrades on very wide and very tall datasets — widget refresh times stretch noticeably past ~50,000 rows. Best practice: keep one Sheet focused on one dataset (e.g., one Sheet for monthly KPIs, another for daily logs), and archive old data into separate sheets when it’s no longer needed for reporting.

• How do I get started with Swydo?

  Sign up for a 14-day free trial or start a subscription. Then:

  • Add team members and set permissions.
  • Customize your account with your branding.
  • Add clients to organize and manage your reports.
  • Integrate integration, other data sources from 35+ platforms or upload your own via Google Sheets.
  • Create & share integration reports using templates or custom widgets.
• Do I need technical skills to use Swydo?

  No, Swydo is designed to be user-friendly and self-service, so no technical skills are required to get started quickly. Our setup guides walk you through every step. If you need assistance, our support team is here to help.

• How can I connect my integration account?

  For a quick overview on how to set up your integration account, check out the integration tutorial on our help center.

• What happens if an integration is not available?
  • You can integrate any data with Swydo using Google Sheets integration. 

  • Manually upload your data or use tools like Zapier or Make to automate syncing from thousands of sources. 
  • This keeps your reports up to date with the metrics that matter most.
• Is my data secure with Swydo?

  Yes, Swydo implements  industry-standard measures to protect your information. This includes secure data storage, encryption, and compliance with privacy regulations. Learn more here.

• Do you offer Report Filters?

  Yes, Swydo offers several filter options to help you refine your data and focus on the most relevant insights. Some of the key filter types include:

  • integration Metric Filters: Refine data based on specific metrics (e.g., impressions, clicks, conversions).
  • Date Filters: Filter integration data by custom date ranges or specific time periods (e.g., weekly, monthly).
  • Dimension Filters: Apply filters based on integration dimensions like campaign, ad group, or device.
  • Inclusion/Exclusion Filters: Specify which integration data to include or exclude from your reports.
• Can I have multiple integrations in the same report?

  Yes, you can combine integration data with multiple integrations into one comprehensive report. This allows you to:

  • Create sections with data from different platforms (e.g., Google Ads, Facebook Ads, Microsoft Ads).
  • Build a holistic view of your marketing performance in one place.

  Perfect for multi-channel campaigns and seamless reporting.

• Is my integration data automatically updated in Swydo?
  • Yes! Swydo always displays the most recent data provided by the integration API.
  • While data isn’t updated live in the background, it refreshes when you open a report or manually refresh the page.
  • This ensures you’re always seeing the latest available integration data from your connected platforms.
• How does Swydo ensure my integration data connections stay reliable?

  Swydo actively monitors your data sources to keep everything running smoothly. If there’s a disruption, such as a password change or account update, you’ll receive an alert in the app, and a detailed email with easy steps to resolve the issue.

   

• What happens after my trial ends?
  • You will need to upgrade to a paid plan to continue using Swydo.
  • Your reports and data remain available for 90 days, giving you time to transition.
• What payment options do you accept?

  We accept credit cards (Visa, Mastercard & American Express) and PayPal.

• Can I cancel my subscription anytime?
  • Yes, you can cancel at any time.
  • Since Swydo operates on a post-payment model, you’ll be billed for data sources used in the current cycle.
  • If you cancel today, you’ll still have access until the end of your billing period, but no further charges will apply.
  • Learn more here.
• Can I pause my subscription and reactivate it later?
  • Yes! For $10/month, you can pause your subscription while keeping your reports and data.
  • You can resume anytime you’re ready.
• What happens to my data if I cancel or stop using Swydo?
  • Your integration reports and data stay available for 90 days after cancellation.
  • After 90 days, your account, data, and reports will be permanently deleted
• What type of support do you offer?
  • Our specialists are available 24/5 on weekdays and typically respond within 15 minutes.
  • You can reach us via the chat button on our website or in the Swydo app, or by email to support@swydo.com 
  • Visit our Help Center for documentation and FAQs.
• Do you offer any onboarding services?

  Yes! Our onboarding ensures a seamless start with:

  • Live demos with a specialist (book anytime).
  • Getting Started series with videos and articles.
  • Follow-up emails with tips and next steps.

  While Swydo is self-service, our support team is always available to help set up your first reports.