Skip to main content

Manage exports using Funnel AI

Create, run and check exports from a Funnel AI chat.

Ask Funnel AI to set up a scheduled export to Google Sheets, Google BigQuery or Google Cloud Storage without leaving the chat. You can also ask about your existing exports and their recent runs, turn an export off or on and run an export right away.

​

Supported destinations

Funnel AI can create exports to Google Sheets, Google BigQuery and Google Cloud Storage. Set up exports to other destinations in Funnel.

Destination

Create from Funnel AI

Create from Funnel MCP

Google Sheets

Yes

Yes

Google BigQuery

Yes

Yes

Google Cloud Storage

Yes

Yes

Snowflake

No

Yes

Looker Studio views

Yes

Yes

Tableau and Power BI views

No

No

Microsoft Excel, Meridian, Microsoft Azure Blob Storage, SFTP, PostgreSQL, Amazon S3 and Amazon Redshift

No

No

In the chat, you can:

​

  • Ask about your exports and views, including Looker Studio, Tableau and Power BI views.

  • Check an export's recent runs, find out why a run failed and get a link to download the files a run wrote.

  • Create an export to Google Sheets, Google BigQuery or Google Cloud Storage.

  • Create a Looker Studio view.

  • Turn an export off or on.

  • Run an export now, for its own date range or for the dates you choose.

​

In the chat, you can't:

​

  • Edit or delete an export. Make those changes on the export in Funnel.

  • Choose a schedule other than daily.

  • Use a Google service account for BigQuery or Cloud Storage exports. To use one, set up the export in Funnel.

  • Create Tableau or Power BI views.

  • Create, turn off, turn on or run an export from a scheduled task. A scheduled task can read your exports and their runs, but it gets no download links.

​

Before you begin

  • You have access to the workspace. This is enough to ask about exports, views and their runs.

  • To create, turn off, turn on or run an export, you have permission to edit exports in the workspace. If you don't, ask your workspace admin for access.

  • To create an export, you have a Google account that can write to the destination: the spreadsheet, the BigQuery project or the Cloud Storage bucket.

​

Ask about your exports

Ask Funnel AI which exports and views the workspace has. Funnel AI lists each one with its name, type, destination and whether it's turned on. Ask about one export to see its fields, date range, filters, currency, schedule and its last and next run.

​

For example:

​

  • Which exports do we have, and which ones are turned off?

  • When did the Weekly spend export last run, and what does it include?

​

Funnel AI can also read Looker Studio, Tableau and Power BI views. Views have no schedule or date range. Funnel AI can show an export's data in the chat and tells you when the result is approximate. It never shows the credentials an export uses.

​

If Funnel turned an export off by itself, Funnel AI tells you why and when, for example after the export failed 20 times in a row.

​

Check an export's runs

Ask Funnel AI whether an export ran, when it last succeeded or why a run failed. For example:

​

  • Did the Weekly spend export run today?

  • Why did the BigQuery cost export fail last night?

  • Give me a link to download the latest run of the Daily cost to Sheets export.

​

Funnel AI lists the export's recent runs, newest first. Each run shows its status, which is Success, Failed, Pending or Stopped. A failed run also shows its error. Ask about one run to see each part it wrote, with the number of rows and columns, the file size and a download link.

Note: A download link works for about an hour, for anyone who has it. Only share it with people who should see the data. Runs older than 30 days have no download link. Except for Google Sheets and Microsoft Excel exports, only the latest run has one.

Create an export

  1. In the top bar, click Show AI chat, or press Cmd+J (Mac) or Ctrl+J (Windows). You can also go to AI > New chat in the left menu.

    ​

  2. Describe the export: the dimensions and metrics, the destination, the date range and what time it should run. For example: Export cost by date and connector for the last 30 days to BigQuery, daily at 06:00.

    ​

    Note: Google BigQuery and Google Cloud Storage exports must include the Date dimension.

    ​

  3. If Funnel AI shows the Connect a Google account card, click Connect Google account and sign in with a Google account that can write to the destination. Then click Check for connections.

    ​

    Note: A Google connection made only for Google Sheets can't write to BigQuery or Cloud Storage. From the chat, BigQuery and Cloud Storage exports use your own Google account. To use a service account, set up the export in Funnel.

    ​

  4. Review the approval card. It shows the destination, the Google account, the dimensions and metrics, the dates, the currency, any filters or data source and the schedule. The card also says what the export changes, for example that it replaces everything in a Google Sheets tab now and on every scheduled run.

    ​

  5. Click Create and run to create the export and start the first run right away, or click Create export. To discard the export, click Cancel.

​

Destinations

Destination

What Funnel writes

Google Sheets

A tab in a new or existing spreadsheet. Each run replaces everything in the tab. You can't use a tab that another export already writes to.

Google BigQuery

A date-partitioned table in your own project, written in monthly parts. The default table name is funnel_data. If the dataset doesn't exist, Funnel creates it. The dataset location defaults to your Funnel region.

Google Cloud Storage

Gzipped CSV files in the folder you choose, one file per month.

Schedule, dates and other options

  • Schedule: Exports you create in the chat run daily at the time and timezone you choose. The default is 06:00 UTC.

  • Dates: Use a rolling range, such as the last 7 days or the last 3 months, with or without complete periods only. Or set a fixed start and end date. The default is the last 30 days.

  • Currency: The export uses the workspace currency unless you ask for no currency conversion.

  • Filters: Filter on dimension values with is, is not or is one of.

  • Data source: You can limit the export to one data source.

​

Create a Looker Studio view

  1. Open a chat and describe the view: the dimensions and metrics you want in Looker Studio. For example: Create a Looker Studio view with cost and impressions by campaign.

    ​

  2. Review the approval card. It shows the dimensions, the metrics and the currency.

    ​

  3. Click Create view.

    ​

  4. Open the link in Funnel AI's reply. Looker Studio opens with the view already selected.

    ​

  5. Authorize Funnel's connector in Looker Studio, then start a report.

​

A view has no date range, so you choose the dates in Looker Studio. Until you open the link and connect the view, you find it in Funnel under Exports. Set up Tableau and Power BI views in Funnel.

​

Turn an export off or on

  1. Ask Funnel AI to turn off or turn on an export. For example: Turn off the Daily cost to Sheets export.

    ​

  2. Review the Turn export off or Turn export on card.

    ​

  3. Click Turn off or Turn on.

​

A turned-off export stops running until you turn it on again. Funnel keeps its configuration.

​

Run an export now

  1. Ask Funnel AI to run an export. For example: Run the BigQuery cost export now for 1 to 15 October.

    ​

  2. Review the Run export now card. The Dates row shows the dates you asked for, or the export's own date range.

    ​

  3. Click Run now.

​

The next scheduled run doesn't change. To run a turned-off export, turn it on first.

​

Ask where you can send data

Ask Funnel AI Where can I send my data? Funnel AI lists the destinations you can set up from the chat. For other destinations, it gives you a link to create the export in Funnel.

​

Choose which changes need your approval

In AI > Tool permissions, under Exports, you can set these actions to Always allow: Create exports, Turn exports on or off and Run exports now. Funnel AI then makes those changes without showing a card, and the chat shows Auto-approved by tool permissions. If a card shows Always allow, click it to approve the change and skip the card for that action from then on. For more, see Manage tool permissions using Funnel AI.

​

Use Funnel MCP

You can do the same tasks from an AI client connected to Funnel MCP, such as Claude or ChatGPT. Your AI client shows you each change and asks you to approve it before Funnel makes it. For the steps and limits, see Manage exports using Funnel MCP.

​

To connect a client, see Quick start guide: Using Funnel MCP.

​

What to expect

The new export appears with your other exports in Funnel and runs every day at the time you set. If you clicked Create and run, the first run starts right away.

​

Funnel can't check up front that your Google account can write to the BigQuery project or Cloud Storage bucket. If the table or files don't appear, ask Funnel AI why the latest run failed, or open the export in Funnel and check its run status.

Did this answer your question?