Automate sending data every month as .csv over e-mail

[Ruak]

Hi,

I have two tables. Table A and Table B. Both get new rows everyday as the app is used. Both tables have multiple columns(around 15).
Is there a way i can schedule sending the data of both tables (in .csv or xlsx format) to a specific gmail every 1st of the month. This would be my workaround for data back up of my essential data
I’m on the explorer plan. (can upgrade to maker if needed).
Is there a way within glide i could do this or do i need to use Make.com(not preferred unless absolutely necessary)?

P.S. - I tried scheduled workflow but couldn’t get it work. And i have no clue how make.com works

@NoCodeAndy Please help!

Thank you,

[Darren_Murphy]

It should be possible with a Scheduled Workflow. Where did you get stuck?

[Ruak]

@Darren_Murphy I’m attaching a few screenshots to explain what’s happening.

1. While setting up when we select generate .csv then there is nothing under the results section on the right hand side(shown in the screenshot) where typically we define where the .csv url will be located(this option comes if we make a user based trigger workflow and hence i have a separate working workflow for manually downloading data)
   

   

2. When i run the workflow, it throws an error 403 at the generate .csv step
   

   

[Darren_Murphy]

I just tested it, and it works perfectly fine

To select the columns for export, you need to click on the “Select Columns” text:

[Ruak]

I did select all the columns i need. It still gets stuck at the generate csv node. Same Error - 403. Could it be because i’m on the explorer plan? Clearly you’ve made the exact workflow and its working for you, i am totally bamboozled now!
I also found another link where in april somebody had a similar issue and you’d solved it : Generate CSV in a Scheduled Workflow - #11 by Darren_Murphy

I also have user specific columns in these data tables. Is that causing an issue ?

[Darren_Murphy]

@Ruak

also have user specific columns in these data tables. Is that causing an issue ?

Yes, absolutely. Scheduled workflows cannot access User Specific columns.

[Ruak]

I just tried it with an new table with just 1 text column to test, and still the same error 403.

[Ruak]

Here’s the exact error :

[Ruak]

@NoCodeAndy @ThinhDinh Please assist
@Darren_Murphy is having no issues in this simple scheduled workflow, while i’m getting the upload failed with status code 403 error, no matter what i do.

Is this bug or a unsaid restriction in my explorer plan ?

[ThinhDinh]

The HTTP 403 Forbidden client error response status code indicates that the server understood the request but refused to process it.

I’m not sure why you would see this. Please try submitting a ticket through the bottom right icon in your builder.