We are trying trying to use this API call to automatically download a csv file to Google Drive.

[RohanSenapaty]

Using the "Export CSV" action. We can't find where and/or if the CSV file is actually generated making this call.

[Austin_QREW]

Hi @RohanSenapaty ,

The "Export CSV" action will only download a view as a CSV file not download it to Google Drive. You maybe able to create this feature using an automation and calling a webhook. We have been using Pipedream to run webhooks and they have a Google Drive connector that could allow you to save files to your Google Drive. May be worth looking into. Let me know if you have any other questions. 

Thanks!

Austin from AppSheet Training

[Kevin_Ra_CEO]

@RohanSenapaty 

Depending on the use case you may be able to export the data in JSON and do whatever you want with it, including convert it to a CSV and store it in Drive.

You may also want to consider running an AppScript to send the CSV right into the drive, or using an app from the Workspace Marketplace (just pay a small fee and its done TODAY) like this:

https://workspace.google.com/marketplace/app/form_publisher/827172627657