# Generate CSV in a Scheduled Workflow **URL:** \ **Category:** Ask for Help\ **Tags:** actions\ **Created:** [April 1, 2025, 3:20pm UTC](https://community.glideapps.com/t/generate-csv-in-a-scheduled-workflow/81098 "2025-04-01T15:20:10Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![StuartPembery](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stuartpembery/32/83235_2.png) [@StuartPembery](https://community.glideapps.com/u/StuartPembery)\ **Post date:** [April 1, 2025, 3:20pm UTC](https://community.glideapps.com/t/generate-csv-in-a-scheduled-workflow/81098/1 "2025-04-01T15:20:10Z")
Hi All.Today I’m being an April Fool! Trying to get a scheduled workflow to generate a CSV and save the URL of the generated file. I’m probably being a complete numpty but for some reason it’s failing. I don’t suppose anybody has got generate csv in a scheduled workflow working?Here’s my approach.Loop around a helper table with a single row - run Generate csv on a ifferent table - try to save the url to the csv in a text column in the helper table - I get a 403 error. Any ideas? Thanks ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 2, 2025, 12:39am UTC](https://community.glideapps.com/t/generate-csv-in-a-scheduled-workflow/81098/2 "2025-04-02T00:39:44Z")
Are any of the fields here, especially the field where you are storing the URL, a user-specific column? Workflows can’t work with user-specific columns since it can’t imitate a user in a run. ---
**Author:** ![StuartPembery](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stuartpembery/32/83235_2.png) [@StuartPembery](https://community.glideapps.com/u/StuartPembery)\ **Post date:** [April 2, 2025, 8:11am UTC](https://community.glideapps.com/t/generate-csv-in-a-scheduled-workflow/81098/3 "2025-04-02T08:11:09Z")
Thanks Thinh. I guessed as much and ‘context’ is what I was struggling with. No user-specific columns and not the user table either. I’m using a loop over a single row helper table in which I have the URL column. I’ve tried the column to be both text and URL. Neither work. Generate CSV collects that data from the table but is failing to upload. ![Screenshot 2025-04-02 090307](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/0/c0cc70c4530f968c04aa684d1a28a076da749d12.png) ![Screenshot 2025-04-02 090253](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/5/156eed98a589744a2453cef0baa045dd0c38fe53.png) ![Screenshot 2025-04-02 090325](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/8/5827fb67019dbac8bb38ab5aa96e82e8b29b3851.png) I guess it’s possible that I’m the first person trying to use Generate in a Scheduled Workflow? Cheers, Stuart ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 2, 2025, 8:21am UTC](https://community.glideapps.com/t/generate-csv-in-a-scheduled-workflow/81098/4 "2025-04-02T08:21:40Z")
It’s weird that 403 suggests a forbidden error. Can you show us how you set that up, and your columns for the “single row helper” table? ---
**Author:** ![StuartPembery](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stuartpembery/32/83235_2.png) [@StuartPembery](https://community.glideapps.com/u/StuartPembery)\ **Post date:** [April 2, 2025, 9:19am UTC](https://community.glideapps.com/t/generate-csv-in-a-scheduled-workflow/81098/5 "2025-04-02T09:19:15Z")
Columns in “Single Row helper” table ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/1/4111d79aa631723adf9cd43f48d913707ef05115.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/8/98a718819d36952685e39b5a0c770dc2f13a4db6.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/b/abc3e5b8bd7e6f80d8b20a1f74c985e3c0ce5216.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 2, 2025, 9:30am UTC](https://community.glideapps.com/t/generate-csv-in-a-scheduled-workflow/81098/6 "2025-04-02T09:30:27Z")
I’m curious. If your table has only one row, what are you looping through? ---
**Author:** ![StuartPembery](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stuartpembery/32/83235_2.png) [@StuartPembery](https://community.glideapps.com/u/StuartPembery)\ **Post date:** [April 2, 2025, 10:28am UTC](https://community.glideapps.com/t/generate-csv-in-a-scheduled-workflow/81098/7 "2025-04-02T10:28:04Z")
Thanks Darren! You question tells me that I might be missing the point completely. My ‘Generate csv’ pulls data from a tickets table. See above picture. The loop is around the single-row helper table to give me somewhere to store the url. It’s quite possible that I’ve got the whole context wrong. In my head, I’m saving a single url to a csv file that is generated from every row in the table defined as Source data in the action. ---
**Author:** ![StuartPembery](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stuartpembery/32/83235_2.png) [@StuartPembery](https://community.glideapps.com/u/StuartPembery)\ **Post date:** [April 2, 2025, 10:28am UTC](https://community.glideapps.com/t/generate-csv-in-a-scheduled-workflow/81098/8 "2025-04-02T10:28:51Z")
I’ll try looping around the Tickets table inside the Helper loop. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 2, 2025, 10:49am UTC](https://community.glideapps.com/t/generate-csv-in-a-scheduled-workflow/81098/9 "2025-04-02T10:49:46Z")
I don’t understand why you need the loop at all. Or the helper table for that matter. Wouldn’t you just point the Generate CSV action directly at the table? (Or a query, if it needs to be filtered) 🤔 ---
**Author:** ![StuartPembery](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stuartpembery/32/83235_2.png) [@StuartPembery](https://community.glideapps.com/u/StuartPembery)\ **Post date:** [April 2, 2025, 10:50am UTC](https://community.glideapps.com/t/generate-csv-in-a-scheduled-workflow/81098/10 "2025-04-02T10:50:06Z")
@Darren_Murphy Tried that. Now it’s just failing 10 times instead of once ☹ ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 2, 2025, 10:51am UTC](https://community.glideapps.com/t/generate-csv-in-a-scheduled-workflow/81098/11 "2025-04-02T10:51:57Z")
I’d try it myself, but I’m out. I’ll have a look later, if you don’t figure it out in the meantime. ---
**Author:** ![StuartPembery](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stuartpembery/32/83235_2.png) [@StuartPembery](https://community.glideapps.com/u/StuartPembery)\ **Post date:** [April 2, 2025, 11:05am UTC](https://community.glideapps.com/t/generate-csv-in-a-scheduled-workflow/81098/12 "2025-04-02T11:05:13Z")
Thanks Darren, it’s not urgent ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 2, 2025, 12:06pm UTC](https://community.glideapps.com/t/generate-csv-in-a-scheduled-workflow/81098/13 "2025-04-02T12:06:40Z")
@StuartPembery - I just had a look at this. Here is what you need to do: - Start with a Single Value node that targets the First-\>Whole row in your Helper Table - Add a Generate CSV node. Ignore the “File Output” option. It does nothing. I suspect that only works with User Initiated workflows (or it might be a bug). - Finally, add a Set Column Values node. Target the column that you want the CSV URL written to via the Single Value, and write the output of the Generate CSV node. Here is what that looks like: ![CleanShot 2025-04-02 at 20.01.19@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/7/67f06c99a13c9f019090754af5329e8c4b9f108c.png) ![CleanShot 2025-04-02 at 20.05.03@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/b/dbf0b15d5799effb04a30645f36f1cc7e50214c9.jpeg) ![CleanShot 2025-04-02 at 20.05.46@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/9/99545cbe28c06e4a2bb50e886646b40112258ee3.png) ---
**Author:** ![StuartPembery](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stuartpembery/32/83235_2.png) [@StuartPembery](https://community.glideapps.com/u/StuartPembery)\ **Post date:** [April 2, 2025, 12:21pm UTC](https://community.glideapps.com/t/generate-csv-in-a-scheduled-workflow/81098/14 "2025-04-02T12:21:36Z")
That’s superb, thanks. Am also quietly pleased that your solution is nothing like the documentation 🙂 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 3, 2025, 1:44am UTC](https://community.glideapps.com/t/generate-csv-in-a-scheduled-workflow/81098/15 "2025-04-03T01:44:48Z")
Can you show the problem with documentation so Glide can fix?