𝟭. 𝗖𝗥𝗘𝗔𝗧𝗘 𝗧𝗛𝗘 𝗔𝗖𝗧𝗜𝗢𝗡 This uses the operator :𝗙𝗢𝗥𝗠𝗔𝗧𝗧𝗘𝗗 𝗔𝗦 𝗧𝗘𝗫𝗧 on a list in Bubble. Get started by using the 𝗖𝗥𝗘𝗔𝗧𝗘 𝗪𝗢𝗥𝗞𝗦𝗛𝗘𝗘𝗧 action to your workflow.

The JSON content field simply needs valid JSON and you are good to go. However, the idea is to do a search for the data you want to export and then use the :𝗙𝗢𝗥𝗠𝗔𝗧 𝗔𝗦 𝗧𝗘𝗫𝗧 operator and create your JSON in that field as shown below.

Add a comma to the Delimiter field.

When you have a field that can contain newlines, quotes, and other special characters, It's a good idea to use the  :𝗙𝗢𝗥𝗠𝗔𝗧𝗧𝗘𝗗 𝗔𝗦 𝗝𝗦𝗢𝗡-𝗦𝗔𝗙𝗘 operator. When using that operator, you don't need to wrap it with double-quotes " -- the operator does that already.

Sample JSON

{
"𝚂𝚊𝚕𝚎 𝙳𝚊𝚝𝚎": "𝚃𝚑𝚒𝚜 𝚂𝚊𝚕𝚎𝚜'𝚜 𝙾𝚛𝚍𝚎𝚛 𝙳𝚊𝚝𝚎",
"𝚂𝚊𝚕𝚎 𝙸𝙳":"𝚃𝚑𝚒𝚜 𝚂𝚊𝚕𝚎𝚜'𝚜 𝙾𝚛𝚍𝚎𝚛 𝙸𝙳",
"𝙸𝚝𝚎𝚖𝚜":[𝚃𝚑𝚒𝚜 𝚂𝚊𝚕𝚎𝚜'𝚜 𝙸𝚝𝚎𝚖𝚜: 𝚏𝚘𝚛𝚖𝚊𝚝𝚝𝚎𝚍 𝚊𝚜 𝙹𝚂𝙾𝙽-𝚜𝚊𝚏𝚎],
"𝚁𝚎𝚐𝚒𝚘𝚗":𝚃𝚑𝚒𝚜 𝚂𝚊𝚕𝚎𝚜'𝚜 𝚁𝚎𝚐𝚒𝚘𝚗'𝚜 𝙽𝚊𝚖𝚎: 𝚏𝚘𝚛𝚖𝚊𝚝𝚝𝚎𝚍 𝚊𝚜 𝙹𝚂𝙾𝙽-𝚜𝚊𝚏𝚎
}

If you want to export a nested list, simply add square brackets around the value as shown in the Items value in the JSON sample.


𝟮. 𝗦𝗔𝗩𝗘 𝗧𝗛𝗘 𝗢𝗨𝗧𝗣𝗨𝗧
Store the output of this action in a text field so that you can use it later on.


𝟯. 𝗥𝗜𝗡𝗦𝗘 𝗔𝗡𝗗 𝗥𝗘𝗣𝗘𝗔𝗧
Create multiple worksheets either in the same workflow or in a recursive workflow.


𝟰. 𝗖𝗥𝗘𝗔𝗧𝗘 𝗧𝗛𝗘 𝗪𝗢𝗥𝗞𝗕𝗢𝗢𝗞
A workbook -- aka spreadsheet file -- can hold various worksheet -- aka tabs.

Take the contents of the previous CREATE WORKSHEET steps and feed them to this action with the corresponding titles of each worksheet.


𝟱. 𝗦𝗔𝗩𝗜𝗡𝗚 𝗧𝗛𝗘 𝗙𝗜𝗟𝗘
To save the file use 1T - CSV Creator's (https://bubble.io/plugin/1t---csv-creator-1582601241392x653181519983018000) save file.

See the demo page for more info


𝟲. 𝗗𝗢𝗪𝗡𝗟𝗢𝗔𝗗𝗜𝗡𝗚 𝗧𝗛𝗘 𝗙𝗜𝗟𝗘
Use the Download file action from AirDev's File Downloader (https://bubble.io/plugin/file-downloader-1539124824422x194279356396994560)