Export recent Facebook Media Assets

NAME

{"name":"Export Account Creative","description":"export_recent_assets_2023-07-21","nodes":{"start_1":{"type":"start","logging_enabled":false,"error_rules":[],"x":12,"y":470},"fb_select_ad_account_ids_v2_1":{"type":"fb_select_ad_account_ids_v2","logging_enabled":false,"error_rules":[],"x":177,"y":158,"inputs":{"ad_account_ids":{"title":"ad_account_ids","description":"Select one or more Facebook Accounts"}}},"stop_1":{"type":"stop","logging_enabled":false,"error_rules":[],"x":1802,"y":729},"map_any_to_table_rows_1":{"type":"map_any_to_table_rows","logging_enabled":false,"error_rules":[],"x":1379,"y":581,"group":"group_1","inputs":{"add_header":{"export_enabled":true},"mapping":{"export_enabled":true,"data":{"A":"/name","B":"/type","C":"/hash","D":"/url","E":"/created_time"}},"schema":{"export_enabled":true,"data":"any_list"}}},"google_sheets_append_table_rows_v3_1":{"type":"google_sheets_append_table_rows_v3","logging_enabled":false,"error_rules":[],"x":1678,"y":281,"group":"group_2","inputs":{"range":{"title":" range","description":"Input the range to search for the table to append to"},"spreadsheet_id":{"title":"  spreadsheet_id","description":"Select a Google Spreadsheet file to append data to"}},"outputs":{"appended":{"title":"appended","description":"Triggered when appended"}}},"map_any_to_table_rows_2":{"type":"map_any_to_table_rows","logging_enabled":false,"error_rules":[],"x":1370,"y":269,"group":"group_2","inputs":{"add_header":{"export_enabled":true},"mapping":{"export_enabled":true,"data":{"A":"/title","B":"/type","C":"/id","D":"/picture","E":"/created_time"}},"schema":{"export_enabled":true,"data":"any_list"}}},"fb_fetch_ad_videos_1":{"type":"fb_fetch_ad_videos","title":"Fetch Facebook Ad Videos","description":"Fetches Ad Videos and their details for the provided Ad Account ids.","logging_enabled":false,"max_job_retries":1,"timeout":90,"error_rules":[],"x":481,"y":258,"group":"group_2"},"input_string_1":{"type":"input_string","logging_enabled":false,"error_rules":[],"x":189,"y":671,"group":"group_3","inputs":{"string":{"export_enabled":true,"data":"2023-06-01"}}},"patch_json_v2_1":{"type":"patch_json_v2","logging_enabled":false,"error_rules":[],"x":530,"y":561,"group":"group_3","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/1/value","value":"{{input.value}}"}]},"data":{"export_enabled":true,"data":[{"operator":"!=","pointer":"/name","value":"untitled"},{"operator":"\u003e","pointer":"/created_time"}]}}},"google_sheets_select_spreadsheet_id_v2_1":{"type":"google_sheets_select_spreadsheet_id_v2","logging_enabled":false,"error_rules":[],"x":583,"y":43,"inputs":{"spreadsheet_id":{"title":"spreadsheet_id","description":"The spreadsheet to fetch from"},"range":{"export_enabled":true,"data":"Assets"}}},"for_each_v2_1":{"type":"for_each_v2","logging_enabled":false,"error_rules":[],"x":531,"y":365},"filter_v2_1":{"type":"filter_v2","logging_enabled":false,"error_rules":[],"x":813,"y":272,"group":"group_2"},"filter_v2_2":{"type":"filter_v2","logging_enabled":false,"error_rules":[],"x":805,"y":560,"group":"group_1"},"fb_fetch_ad_images_1":{"type":"fb_fetch_ad_images","title":"Fetch Facebook Ad Images","description":"Fetches Ad Images and their details for the provided Ad Account ids.","logging_enabled":false,"max_job_retries":1,"timeout":90,"error_rules":[],"x":522,"y":543,"group":"group_1"},"google_sheets_append_table_rows_v3_2":{"type":"google_sheets_append_table_rows_v3","logging_enabled":false,"error_rules":[],"x":1667,"y":613,"group":"group_1","inputs":{"range":{"title":" range","description":"Input the range to search for the table to append to"},"spreadsheet_id":{"title":"  spreadsheet_id","description":"Select a Google Spreadsheet file to append data to"}}},"google_sheets_fetch_table_rows_v3_1":{"type":"google_sheets_fetch_table_rows_v3","logging_enabled":false,"error_rules":[],"x":390,"y":562,"group":"group_4","inputs":{"value_render_option":{"export_enabled":true,"data":"FORMATTED_VALUE"},"date_time_render_option":{"export_enabled":true,"data":"FORMATTED_STRING"},"dimension":{"export_enabled":true,"data":"ROWS"}}},"google_sheets_update_table_rows_v2_1":{"type":"google_sheets_update_table_rows_v2","logging_enabled":false,"error_rules":[],"x":3005,"y":713,"group":"group_4"},"patch_json_v2_2":{"type":"patch_json_v2","logging_enabled":false,"error_rules":[],"x":2463,"y":661,"group":"group_4","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/0","value":"{{input.value}}"}]},"data":{"export_enabled":true,"data":[]}}},"for_each_v2_2":{"type":"for_each_v2","logging_enabled":false,"error_rules":[],"x":1422,"y":617,"group":"group_4"},"google_sheets_fetch_table_row_mapping_1":{"type":"google_sheets_fetch_table_row_mapping","logging_enabled":false,"error_rules":[],"x":666,"y":564,"group":"group_4"},"filter_v2_3":{"type":"filter_v2","logging_enabled":false,"error_rules":[],"x":1173,"y":654,"group":"group_4","inputs":{"filters":{"export_enabled":true,"data":[{"operator":"contains","pointer":"/data/type","value":"ad"},{"operator":"not_contains","pointer":"/data/thumbnail","value":"kitchnware"}]}}},"patch_json_v3_1":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1688,"y":616,"group":"group_4","inputs":{"patches":{"export_enabled":true,"data":[{"op":"move","from":"/data/thumbnail","path":""}]},"value":{"export_enabled":true}}},"map_table_rows_1":{"type":"map_table_rows","logging_enabled":false,"error_rules":[],"x":931,"y":598,"group":"group_4","inputs":{"schema":{"export_enabled":true,"data":"any"}}},"clone_file_v2_1":{"type":"clone_file_v2","logging_enabled":false,"error_rules":[],"x":1948,"y":687,"group":"group_4"},"patch_json_v2_3":{"type":"patch_json_v2","logging_enabled":false,"error_rules":[],"x":2211,"y":638,"group":"group_4","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/data/thumbnail","value":"{{input.value}}"}]}}},"unmap_table_rows_1":{"type":"unmap_table_rows","logging_enabled":false,"error_rules":[],"x":2733,"y":681,"group":"group_4","inputs":{"schema":{"export_enabled":true,"data":"any"}}},"google_sheets_select_spreadsheet_id_v2_2":{"type":"google_sheets_select_spreadsheet_id_v2","title":"Relay Google Spreadsheet Id","description":"Selects spreadsheet id from a list of options and can set a range","logging_enabled":false,"max_job_retries":6,"timeout":30,"error_rules":[],"x":74,"y":306,"group":"group_4","inputs":{"spreadsheet_id":{"title":" spreadsheet_id","description":"The spreadsheet to fetch from"}}},"patch_json_list_v2_1":{"type":"patch_json_list_v2","logging_enabled":false,"error_rules":[],"x":1087,"y":274,"group":"group_2","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/type","value":"ad_video"}]},"value":{"export_enabled":true}}},"patch_json_list_v2_2":{"type":"patch_json_list_v2","logging_enabled":false,"error_rules":[],"x":1097,"y":554,"group":"group_1","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/type","value":"ad_image"}]},"value":{"export_enabled":true}}}},"edges":[{"id":"filter_v2_1.items:patch_json_list_v2_1.data_list","points":[]},{"id":"filter_v2_1.filtered:patch_json_list_v2_1.patch","points":[]},{"id":"patch_json_list_v2_1.data_list:map_any_to_table_rows_2.data","points":[]},{"id":"filter_v2_2.filtered:patch_json_list_v2_2.patch","points":[]},{"id":"patch_json_list_v2_2.patched:map_any_to_table_rows_1.map","points":[]},{"id":"patch_json_list_v2_1.patched:map_any_to_table_rows_2.map","points":[]},{"id":"filter_v2_2.items:patch_json_list_v2_2.data_list","points":[]},{"id":"patch_json_list_v2_2.data_list:map_any_to_table_rows_1.data","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id:google_sheets_append_table_rows_v3_1.spreadsheet_id","points":[]},{"id":"fb_select_ad_account_ids_v2_1.ad_account_ids:for_each_v2_1.items","points":[]},{"id":"map_any_to_table_rows_2.mapped:google_sheets_append_table_rows_v3_1.append","points":[]},{"id":"map_any_to_table_rows_1.mapped:google_sheets_append_table_rows_v3_2.append","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_1.range:google_sheets_append_table_rows_v3_1.range","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_1.range:google_sheets_append_table_rows_v3_2.range","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id:google_sheets_append_table_rows_v3_2.spreadsheet_id","points":[]},{"id":"for_each_v2_1.item:fb_fetch_ad_images_1.ad_account_id","points":[]},{"id":"for_each_v2_1.item:fb_fetch_ad_videos_1.ad_account_id","points":[]},{"id":"input_string_1.string:patch_json_v2_1.value","points":[]},{"id":"start_1.start:patch_json_v2_1.patch","points":[]},{"id":"patch_json_v2_1.patched:for_each_v2_1.start","points":[]},{"id":"fb_fetch_ad_videos_1.ad_videos:filter_v2_1.items","points":[]},{"id":"fb_fetch_ad_videos_1.fetched:filter_v2_1.filter","points":[]},{"id":"for_each_v2_1.do:fb_fetch_ad_videos_1.fetch","points":[]},{"id":"fb_fetch_ad_images_1.ad_images:filter_v2_2.items","points":[]},{"id":"fb_fetch_ad_images_1.fetched:filter_v2_2.filter","points":[]},{"id":"map_any_to_table_rows_2.rows:google_sheets_append_table_rows_v3_1.rows","points":[]},{"id":"google_sheets_append_table_rows_v3_1.appended:fb_fetch_ad_images_1.fetch","points":[]},{"id":"map_any_to_table_rows_1.rows:google_sheets_append_table_rows_v3_2.rows","points":[]},{"id":"for_each_v2_1.done:google_sheets_fetch_table_rows_v3_1.fetch","points":[]},{"id":"google_sheets_fetch_table_rows_v3_1.rows:map_table_rows_1.rows","points":[]},{"id":"unmap_table_rows_1.rows:google_sheets_update_table_rows_v2_1.rows","points":[]},{"id":"patch_json_v2_2.data:unmap_table_rows_1.mapped_rows","points":[]},{"id":"patch_json_v2_2.patched:unmap_table_rows_1.unmap","points":[]},{"id":"for_each_v2_2.do:patch_json_v3_1.patch","points":[]},{"id":"patch_json_v3_1.data:clone_file_v2_1.url","points":[]},{"id":"patch_json_v3_1.patched:clone_file_v2_1.clone","points":[]},{"id":"clone_file_v2_1.url:patch_json_v2_3.value","points":[]},{"id":"for_each_v2_2.item:patch_json_v2_3.data","points":[]},{"id":"clone_file_v2_1.cloned:patch_json_v2_3.patch","points":[]},{"id":"patch_json_v2_3.data:patch_json_v2_2.value","points":[]},{"id":"patch_json_v2_3.patched:patch_json_v2_2.patch","points":[]},{"id":"for_each_v2_2.item:patch_json_v3_1.data","points":[]},{"id":"google_sheets_fetch_table_rows_v3_1.fetched:google_sheets_fetch_table_row_mapping_1.fetch","points":[]},{"id":"google_sheets_fetch_table_row_mapping_1.mapping:map_table_rows_1.mapping","points":[]},{"id":"google_sheets_fetch_table_row_mapping_1.fetched:map_table_rows_1.map","points":[]},{"id":"map_table_rows_1.mapped_rows:filter_v2_3.items","points":[]},{"id":"map_table_rows_1.mapped:filter_v2_3.filter","points":[]},{"id":"filter_v2_3.filtered:for_each_v2_2.start","points":[]},{"id":"google_sheets_fetch_table_row_mapping_1.mapping:unmap_table_rows_1.mapping","points":[]},{"id":"unmap_table_rows_1.unmapped:google_sheets_update_table_rows_v2_1.update","points":[]},{"id":"google_sheets_update_table_rows_v2_1.updated:for_each_v2_2.next","points":[]},{"id":"for_each_v2_2.done:stop_1.stop","points":[]},{"id":"patch_json_v2_1.data:filter_v2_1.filters","points":[]},{"id":"patch_json_v2_1.data:filter_v2_2.filters","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_2.spreadsheet_id:google_sheets_fetch_table_rows_v3_1.spreadsheet_id","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_2.spreadsheet_id:google_sheets_fetch_table_row_mapping_1.spreadsheet_id","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_2.spreadsheet_id:google_sheets_update_table_rows_v2_1.spreadsheet_id","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_2.range:google_sheets_fetch_table_rows_v3_1.range","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_2.range:google_sheets_fetch_table_row_mapping_1.range","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id:google_sheets_select_spreadsheet_id_v2_2.spreadsheet_id","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_1.range:google_sheets_select_spreadsheet_id_v2_2.range","points":[]},{"id":"google_sheets_append_table_rows_v3_2.appended:for_each_v2_1.next","points":[{"x":499,"y":487},{"x":499,"y":378},{"x":499,"y":276},{"x":1365,"y":276},{"x":1460,"y":276},{"x":1460,"y":556},{"x":1460,"y":573}]},{"id":"filter_v2_3.items:for_each_v2_2.items","points":[]}],"groups":{"group_3":{"title":"Build Filter","description":"","x":180,"y":380,"inputs":["patch_json_v2_1.patch"],"outputs":["patch_json_v2_1.data","patch_json_v2_1.patched"]},"group_2":{"title":"Export Videos","description":"","x":900,"y":329,"inputs":["google_sheets_append_table_rows_v3_1.range","google_sheets_append_table_rows_v3_1.spreadsheet_id","fb_fetch_ad_videos_1.fetch","fb_fetch_ad_videos_1.ad_account_id","filter_v2_1.filters"],"outputs":["google_sheets_append_table_rows_v3_1.appended"]},"group_1":{"title":"Export Images","description":"","x":1200,"y":332,"inputs":["filter_v2_2.filters","fb_fetch_ad_images_1.fetch","fb_fetch_ad_images_1.ad_account_id","google_sheets_append_table_rows_v3_2.range","google_sheets_append_table_rows_v3_2.spreadsheet_id"],"outputs":["google_sheets_append_table_rows_v3_2.appended"]},"group_4":{"title":"Replace non-kitchn screenshots","description":"","x":1511,"y":568,"inputs":["google_sheets_fetch_table_rows_v3_1.fetch","google_sheets_select_spreadsheet_id_v2_2.spreadsheet_id","google_sheets_select_spreadsheet_id_v2_2.range"],"outputs":["for_each_v2_2.done"]}},"widgets":{"widget_1":{"title":"Date Filter","description":"Exports all assets uploaded after this point in time. Enter date in the format `YYYY-MM-DD`, e.g. `2023-06-01`.\nNote that larger data sets may take significantly longer to export due to the \"screenshot replacement\" step which makes sure you can preview the asset in the spreadsheet permanently.","position":4,"icon":"las la-filter","input":"input_string_1.string"},"widget_2":{"title":"Spreadsheet","description":"The spreadsheet to fetch from","position":1,"input":"google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id"},"widget_3":{"title":"Tab","description":"Select a tab","position":2,"icon":"las la-table","input":"google_sheets_select_spreadsheet_id_v2_1.range"},"widget_4":{"title":"Ad Accounts","description":"Select one or more Facebook Accounts","position":0,"input":"fb_select_ad_account_ids_v2_1.ad_account_ids"}},"variables":{},"config":{"capture_inputs_enabled":false,"caching_enabled":false},"tags":[]}