Using a Bot to Schedule the Export a Slice to a CSV or Sheet

AppSheet AppSheet Q&A
1

I apologize for asking Grok first. Grok failed me; it was both confident and wrong. Or maybe I just didn’t understand.

I need to schedule a bot to run daily and export a slice to a Google Sheet (preferred) or CSV file to a particular Google Drive location.

I know how to create Export to CSV actions. I know how to create Bots. I also have at my disposal a GCP project with APIs and Services enabled. I have a snippet of an AppScript that may come pretty close.

I’ve spun myself dizzy exploring all these avenues. Happy to share code, but I’m at the point where I’m not even sure if what I’m trying to accomplish is possible. Direction would be nice.

2

Try the following.

Schedule a bot with a Create a new file step. Set the HTTP Content Type to CSV.

You can use a template (a text file) something like

"id.misc01","fld1"
<<Start: Slice_table[key field]>>"<<[fld1]>>","<<[fld2]>>"
<<End>>

You can customize the file path and name

TeeSee1_0-1747282598551.png
TeeSee1_0-1747282598551.png412×634 30.5 KB

3

@TeeSee1 This is ultimately what I landed on. It was both harder and easier than I anticipated. I was able to create two schedule-based bots to export two CSV files, and then leveraged a scheduled Apps Script from a Google Sheet to combine those CSV files into one tab of the Google Sheet. This will make my weekend much more enjoyable.

Thanks for the direction. Sometimes all one needs is fewer choices. Your assistance is greatly appreciated.

4

This has been a long outstanding issue which remains.

The workaround is required as the table only selects or defaults to the main table and does not allow any slice to be selected. Thus when a template is autoctreated it always uses the default table name?

Hence one must manually edit the template file. I am using the excel template.

Below it shows main table table KSD AUDIT DATA when what I require is the CAPTURED DATA TODAY slice.

The last or bottom tab only allows the main table to be accessed and should rather provide a dropdown downlist of all available spreadsheet tables and their slices.

image
image356×378 16 KB

5

This is addressed in @TeeSee1’s suggested template:

image
image666×264 28.8 KB

1 Like
6

Hi Steve,

Thanks I am fully aware of this. But that is the workaround. The actual source of the bug has still not been addressed as I have indicated since 2023!

Surely, changing to a drop down list as I have indicated will fully resolve matters?

Otherwise, each user trying to do this will forever have to try and fathom it out like I did.

Cheers

Greg Diana

7

It’s not a bug, so there’s nothing to "fix’.