Exporting Reports to Google Services

Exporting Reports to Google Services

There are a few different ways of exporting the contents of a Wink report into Google Sheets or Google Drive. The appropriate method depends on your use case - especially if you're intending to snapshot data, or import it live for further manipulation.

Google Sheets

The IMPORTDATA function can be used to pull live data from Wink Reports into Google Sheets. Use the following steps:
  1. Check the design of the report you wish to export into Google Sheets and ensure that CSV export is enabled in the advanced options tab
  2. View the report and select the filter values that will be applied to the export
  3. Create a Sharing URL for the export
  4. Visit the generated sharing URL, and add ?inline=1&csv=1 to the URL in the browser. If you visit the modified URL, you should get a CSV file downloaded.
  5. In a blank Google Sheets sheet, add the following formula to cell A1:
    =IMPORTDATA("<long sharing URL here>")
  6. Google Sheets should fetch the CSV file generated by Wink and insert it into your sheet.
There are some other tweaks to try if the CSV import isn't exactly to your liking:
  1. Try adding only ?inline=1 to the URL and using IMPORTHTML:
    =IMPORTHTML("<long sharing URL here>", "table", 1)
  2. Try adding ?inline=1&excel=1 and using IMPORTRANGE:
    =IMPORTRANGE("<long sharing URL here>", "sheet1!A1:C10")

Google Drive via Email Schedules

The easiest way to copy a Wink report into Google Drive is via an email schedule + Zapier.

Zapier have a recipe which gives you a unique email address, and will add any received attachments to Google Drive. You can configure the zap to either replace an existing file, or always create a new file so that a history is kept.

The file saved in Drive will be the same format selected in the email schedule configuration. Excel or CSV are good choices for further manipulation and analysis. PDF is a good choice for saving an audit trail which can't be modified.

Files saved in Drive can be downloaded to your computer or opened in Google Sheets for editing.

Google Drive via Automations

The email schedule technique works similary well when using automations.

Configure the automation to send an email with attachment to the Zapier generated email address to get the Wink report into Google Drive.
    • Related Articles

    • Running Reports

      Created by: Gavin Hodge Modified on: Wed, 14 Feb, 2018 at 3:38 PM Executing reports is the core part of Wink Reports. This reference will cover changing filter values, exporting, using saved filters, parameter lists, and creating sharing URLs. The ...
    • Merging Reports

      Created by: Johann Du Toit Modified on: Tue, 3 Dec, 2019 at 12:45 PM This tutorial will give a quick overview of how you can merge multiple reports and data sources into a single report. Note: This functionality is only available on Professional and ...
    • Why won't my Google Email server connect?

      Check if the SMTP server configuration is correct. You can connect directly to Google Mail using the settings shown below Setting Value Outgoing mail server smtp.gmail.com Port 587 Use TLS Yes Otherwise, the issue is most likely that you need to ...
    • Navigating your Reports Listing

      Over time the list of reports you create will grow.  There are many features within the reports page that will help your organise your list and find the report you need in no time.  Grouping your List Use the Short List options to group your list ...
    • How to change your Wink Reports password

      Created by: Natasha Gromek Modified on: Wed, 14 Feb, 2018 at 1:40 PM Outline Changing your password is an important part of keeping your account secure. Follow these steps to change your Wink Reports Password. Note: this assumes you are currently ...