Upload new assets (Dropbox → Facebook)

Upload Assets from Dropbox

{"name":"Upload new assets (Dropbox)","description":"upload_assets_dropbox_2023028","nodes":{"stop_1":{"type":"stop","logging_enabled":false,"x":1371,"y":702},"fb_select_ad_account_id_v2_1":{"type":"fb_select_ad_account_id_v2","logging_enabled":false,"x":211,"y":119,"group":"group_1","inputs":{"ad_account_id":{"title":"ad_account_id","description":"Select a Facebook Account"}}},"trigger_relay_1":{"type":"trigger_relay","logging_enabled":false,"x":2232,"y":769,"group":"group_1"},"data_relay_1":{"type":"data_relay","title":"Relay URL","description":"Relays data","logging_enabled":false,"x":84,"y":809,"group":"group_1","inputs":{"data":{"title":"url","description":"Data to relay"}}},"google_sheets_select_spreadsheet_id_v2_1":{"type":"google_sheets_select_spreadsheet_id_v2","logging_enabled":false,"x":638,"y":66,"group":"group_1","inputs":{"range":{"export_enabled":true,"data":"Assets"},"spreadsheet_id":{"export_enabled":true,"data":{"id":"1tym_BkhWQBQ4AXnMCSAJueuAxYO6bPkkO-xgu7giVMw","context":{"mime_type":"application/vnd.google-apps.spreadsheet","ui":{"id":"1tym_BkhWQBQ4AXnMCSAJueuAxYO6bPkkO-xgu7giVMw","name":"[Template] Facebook Bulk Ad Creation [Kitchn.io] [2022-12-17]","owners":[{"displayName":"Simon Kreienbaum","kind":"drive#user","me":true,"permissionId":"01137890803721275589","emailAddress":"simon@kitchn.io","photoLink":"https://lh3.googleusercontent.com/a-/ACB-R5SLBnYPQs1TuCD8FwP4oNtd689nkHASb6a8d2EZRIO4g3jLXH3ymyCMa0P_LB8jkmcCv7P-a76nsED4qYtBstlicKkioFoik8uEDD3T8CCxPrA0s8HsYSIzt8B5tj1uolSMZhl2GoNJTCbvVXWMcYnqU9F2O-_-u8560-jDdHI2ebQXlJXzzCWWHrkwpM3X5nk1NokxvSBl-u9Zyh78Yp49p1BjmDb_2Uamn-uPWLxpWna4g9p3nc437uJKm412VLF110-cfq_C96X37u2vLQKQxDSUl0UxR6WBOtYJVEW1g4OgF_zS_36Qop3M0s9lBxI1FpEfheXa4p-JMN57qDVhz8WRaKMLpIs9OT7AJ1Yk20PB8WXyRGPjCKgwOoZtVD5qfd2yQQJu0Tyy0a7pSkDLE_zZ-jTM6kP2gKpXMDJ-QjVk7xa7bIt_Zzvy_4o81sCa9TJu9P9BIqveYMJcrdyX3biBW7uEScBuCy-3bOFNIp0Uu2jkoa3suRAxLIb7WXoeem6rqrwKMAsR4YeMm4tgb-Qy7NfWgCgaAWQiMQvBVMUUWcnYzV4ojkcYqGMuUHoJOqlPXuWQFU_uxuXr8FsLAsDoT9rVj4LXpijFSBIQ1eqfkAI_YO-1cz-YnHKSz1iZU_8jbDCpjqg-gxJQyUIjjIB4VNyu1S5wq8iFjtMqhzXSJS3GK0bnjzhuPdmhbRmnfp9bqUqo_A1ITodEzfHGtjvZeqH5RfMll3_NdYI6YNFPY7T_WBSIsOzMLr8Aqt5ODLSQKOF50QpzKviPpvURbox52Pltc9NyTyroMWqA8jpHLcswKLELaUNOX55imuhINyinMBhMYQHYS8K4g7JhbaKiJnKNGZLs6l853KJtnAR88iIjiz6ysJ96HOP3N4zdqtdyhY_WZIpnsBHz58oNnJiGFDcqm7LjrUhu15mQi0p5raFNI4xk5vv4=s64"}],"mime_type":"application/vnd.google-apps.spreadsheet"}},"provider":"google_drive","type":"file"}}}},"data_relay_2":{"type":"data_relay","title":"Relay Name","description":"Relays data","logging_enabled":false,"x":50,"y":506,"group":"group_1","inputs":{"data":{"title":"name","description":"Data to relay"}}},"fb_create_ad_image_v3_1":{"type":"fb_create_ad_image_v3","logging_enabled":false,"x":836,"y":827,"group":"group_1"},"fb_create_ad_video_v3_1":{"type":"fb_create_ad_video_v3","logging_enabled":false,"x":817,"y":386,"group":"group_1"},"extract_1":{"type":"extract_v2","logging_enabled":false,"x":2086,"y":796,"group":"group_2","inputs":{"pointer":{"export_enabled":true,"data":"/context/image/url"}}},"patch_json_v2_1":{"type":"patch_json_v2","logging_enabled":false,"x":849,"y":231,"group":"group_3","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/context/asset_name","value":"{{input.value}}"}]}}},"patch_json_v2_2":{"type":"patch_json_v2","logging_enabled":false,"x":593,"y":197,"group":"group_3","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/context/image/url","value":"{{input.value}}"}]}}},"map_any_to_table_rows_1":{"type":"map_any_to_table_rows","logging_enabled":false,"x":1117,"y":227,"group":"group_3","inputs":{"add_header":{"export_enabled":true,"data":true},"mapping":{"export_enabled":true,"data":{"A":"/context/asset_name","B":"/type","C":"/context/image/hash","D":"/context/image/url"}},"schema":{"export_enabled":true,"data":"any"}}},"extract_2":{"type":"extract_v2","logging_enabled":false,"x":2082,"y":520,"group":"group_4","inputs":{"pointer":{"export_enabled":true,"data":"/context/thumbnail/uri"}}},"clone_file_v2_1":{"type":"clone_file_v2","logging_enabled":false,"x":2463,"y":301,"group":"group_4"},"map_any_to_table_rows_2":{"type":"map_any_to_table_rows","logging_enabled":false,"x":1483,"y":293,"group":"group_5","inputs":{"add_header":{"export_enabled":true,"data":true},"mapping":{"export_enabled":true,"data":{"A":"/context/asset_name","B":"/type","C":"/id","D":"/context/thumbnail/uri"}},"schema":{"export_enabled":true,"data":"any"}}},"patch_json_v2_3":{"type":"patch_json_v2","logging_enabled":false,"x":704,"y":267,"group":"group_5","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/context/thumbnail/uri","value":"{{input.value}}"}]}}},"clone_file_v2_2":{"type":"clone_file_v2","logging_enabled":false,"x":2480,"y":639,"group":"group_2"},"post_integration_url_v2_1":{"type":"post_integration_url_v2","logging_enabled":false,"x":934,"y":493,"group":"group_6","inputs":{"headers":{"export_enabled":true},"url":{"export_enabled":true,"data":"https://api.dropboxapi.com/2/files/get_temporary_link"},"provider":{"export_enabled":true,"data":"dropbox"}}},"post_integration_url_v2_2":{"type":"post_integration_url_v2","logging_enabled":false,"x":964,"y":382,"group":"group_7","inputs":{"headers":{"export_enabled":true},"url":{"export_enabled":true,"data":"https://api.dropboxapi.com/2/files/list_folder"},"provider":{"export_enabled":true,"data":"dropbox"}}},"google_sheets_append_table_rows_v3_1":{"type":"google_sheets_append_table_rows_v3","logging_enabled":false,"x":1877,"y":909,"group":"group_1"},"patch_json_v2_4":{"type":"patch_json_v2","logging_enabled":false,"x":975,"y":288,"group":"group_5","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/context/asset_name","value":"{{input.value}}"}]}}},"start_1":{"type":"start","logging_enabled":false,"x":38,"y":423},"for_each_v2_1":{"type":"for_each_v2","logging_enabled":false,"x":1054,"y":267},"extract_3":{"type":"extract_v2","logging_enabled":false,"x":1273,"y":564,"group":"group_6","inputs":{"pointer":{"export_enabled":true,"data":"/link"}},"outputs":{"data":{"title":"temp_file_link","description":"The extracted data"}}},"extract_4":{"type":"extract_v2","logging_enabled":false,"x":1622,"y":573,"group":"group_6","inputs":{"pointer":{"export_enabled":true,"data":"/metadata/name"}},"outputs":{"extracted":{"title":"extracted","description":"Triggers when the data was extracted"},"data":{"title":"file_name","description":"The extracted data"}}},"patch_json_v2_5":{"type":"patch_json_v2","logging_enabled":false,"x":496,"y":412,"group":"group_6","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/path","value":"{{input.value/path_lower}}"}]},"data":{"export_enabled":true,"data":{"path":""}}}},"google_sheets_fetch_table_rows_v3_1":{"type":"google_sheets_fetch_table_rows_v3","logging_enabled":false,"x":509,"y":284,"group":"group_8","inputs":{"date_time_render_option":{"export_enabled":true,"data":"FORMATTED_STRING"},"value_render_option":{"export_enabled":true,"data":"UNFORMATTED_VALUE"},"dimension":{"export_enabled":true,"data":"ROWS"}}},"extract_list_1":{"type":"extract_list","logging_enabled":false,"x":780,"y":406,"group":"group_8","inputs":{"pointer":{"export_enabled":true,"data":"/columns/0"}},"outputs":{"extracted":{"title":"extracted","description":"Triggers when the data was extracted"},"data_list":{"title":"existing_assets","description":"The extracted data"}}},"filter_v2_1":{"type":"filter_v2","logging_enabled":false,"x":309,"y":313,"group":"group_9","inputs":{"filters":{"export_enabled":true,"data":[{"value":"(.mp4|.m4v|.mov|.gif|.jpg|.jpeg|.png)","pointer":"/name","operator":"matches"}]}},"outputs":{"filtered":{"title":"filtered","description":"Triggered when filtered"}}},"google_sheets_append_table_rows_v3_2":{"type":"google_sheets_append_table_rows_v3","logging_enabled":false,"x":1916,"y":419,"group":"group_1"},"extract_5":{"type":"extract_v2","logging_enabled":false,"x":1259,"y":489,"group":"group_7","inputs":{"pointer":{"export_enabled":true,"data":"/entries"}},"outputs":{"extracted":{"title":"extracted","description":"Triggers when the data was extracted"}}},"extract_6":{"type":"extract_v2","logging_enabled":false,"x":2144,"y":423,"group":"group_7","inputs":{"pointer":{"export_enabled":true,"data":"/entries"}},"outputs":{"extracted":{"title":"extracted","description":"Triggers when the data was extracted"}}},"patch_json_v2_6":{"type":"patch_json_v2","logging_enabled":false,"x":1531,"y":340,"group":"group_7","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/cursor","value":"{{input.value/cursor}}"}]},"data":{"export_enabled":true,"data":{"cursor":""}}}},"post_integration_url_v2_3":{"type":"post_integration_url_v2","logging_enabled":false,"x":1844,"y":299,"group":"group_7","inputs":{"headers":{"export_enabled":true},"url":{"export_enabled":true,"data":"https://api.dropboxapi.com/2/files/list_folder/continue"},"provider":{"export_enabled":true,"data":"dropbox"}}},"concat_1":{"type":"concat","logging_enabled":false,"x":2463,"y":600,"group":"group_7","inputs":{"schema":{"export_enabled":true,"data":"any"}}},"patch_json_v2_7":{"type":"patch_json_v2","logging_enabled":false,"x":644,"y":357,"group":"group_7","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/recursive","value":"{{input.value}}"}]},"data":{"title":"body","description":"The data the patches are applied to"}}},"patch_json_v2_8":{"type":"patch_json_v2","logging_enabled":false,"x":320,"y":258,"group":"group_7","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/path","value":"{{input.value}}"}]},"data":{"title":"body","description":"The data the patches are applied to","export_enabled":true,"data":{"path":"","recursive":false,"limit":2000}}}},"input_string_1":{"type":"input_string","title":"Path","description":"Allows to input a string","logging_enabled":false,"max_job_retries":6,"timeout":30,"x":61,"y":259,"group":"group_7","inputs":{"string":{"title":"path","description":"A string to input","export_enabled":true,"data":"/creatives/2023/February"}}},"input_boolean_1":{"type":"input_boolean","logging_enabled":false,"x":362,"y":649,"group":"group_7","inputs":{"boolean":{"export_enabled":true,"data":true}}},"filter_v2_2":{"type":"filter_v2","logging_enabled":false,"x":2749,"y":655,"group":"group_7","inputs":{"filters":{"export_enabled":true,"data":[{"operator":"=","pointer":"/is_downloadable","value":true}]}}},"if_v2_1":{"type":"if_v2","logging_enabled":false,"x":1018,"y":514,"group":"group_10","inputs":{"condition":{"export_enabled":true,"data":"in"},"a":{"export_enabled":true,"data":".png"}},"outputs":{"false":{"title":"is_video","description":"Triggers when the evaluation is false"}}},"data_relay_3":{"type":"data_relay","logging_enabled":false,"x":292,"y":572,"group":"group_10","inputs":{"data":{"title":"name","description":"Data to relay"}}},"extract_list_2":{"type":"extract_list","logging_enabled":false,"x":638,"y":516,"group":"group_9","inputs":{"pointer":{"export_enabled":true,"data":"/name"}}},"if_v2_2":{"type":"if_v2","logging_enabled":false,"x":667,"y":317,"group":"group_10","inputs":{"condition":{"export_enabled":true,"data":"in"},"a":{"export_enabled":true,"data":".jp"}}},"trigger_relay_2":{"type":"trigger_relay","logging_enabled":false,"x":1408,"y":567,"group":"group_10","outputs":{"relayed":{"title":"is_image","description":"Output trigger from relay"}}},"filter_v2_3":{"type":"filter_v2","logging_enabled":false,"x":1867,"y":627,"group":"group_9","inputs":{"filters":{"export_enabled":true,"data":[{"operator":"!=","pointer":"/check","value":null}]}}},"join_data_1":{"type":"join_data","logging_enabled":false,"x":1556,"y":473,"group":"group_9","inputs":{"conditions":{"title":"conditions","description":"Conditions the lists get joined by","export_enabled":true,"data":[{"a":"/name","b":"/name"}]},"target":{"export_enabled":true,"data":"/check"}}},"calculate_set_operation_1":{"type":"calculate_set_operation","logging_enabled":false,"x":952,"y":665,"group":"group_9","inputs":{"operator":{"export_enabled":true,"data":"-"},"b":{"title":"b: existing_assets","description":"Set B"}}},"patch_json_list_v2_1":{"type":"patch_json_list_v2","logging_enabled":false,"x":1492,"y":709,"group":"group_11","inputs":{"patches":{"export_enabled":true,"data":[{"op":"move","path":"/name","from":"/id"},{"op":"remove","path":"/provider"},{"op":"remove","path":"/type"}]},"value":{"export_enabled":true}}},"parse_strings_to_ids_1":{"type":"parse_strings_to_ids","logging_enabled":false,"x":1224,"y":729,"group":"group_11","inputs":{"schema":{"export_enabled":true,"data":"snapchat_ad_account_id"}}}},"edges":["post_integration_url_v2_2.body:extract_5.data","patch_json_v2_6.patched:post_integration_url_v2_3.post","post_integration_url_v2_3.body:extract_6.data","post_integration_url_v2_2.posted:extract_5.extract","post_integration_url_v2_2.body:patch_json_v2_6.value","post_integration_url_v2_3.posted:extract_6.extract","patch_json_v2_6.data:post_integration_url_v2_3.body","extract_6.extracted:concat_1.concat","extract_6.data:concat_1.a","extract_5.data:concat_1.b","extract_5.extracted:patch_json_v2_6.patch","for_each_v2_1.done:stop_1.stop","post_integration_url_v2_1.posted:extract_3.extract","patch_json_v2_5.patched:post_integration_url_v2_1.post","extract_2.data:clone_file_v2_1.url","extract_2.extracted:clone_file_v2_1.clone","extract_1.data:clone_file_v2_2.url","extract_1.extracted:clone_file_v2_2.clone","fb_create_ad_video_v3_1.ad_video_id:extract_2.data","fb_create_ad_image_v3_1.ad_image_id:extract_1.data","clone_file_v2_1.url:patch_json_v2_3.value","clone_file_v2_1.cloned:patch_json_v2_3.patch","patch_json_v2_3.data:patch_json_v2_4.data","patch_json_v2_3.patched:patch_json_v2_4.patch","map_any_to_table_rows_2.rows:google_sheets_append_table_rows_v3_2.rows","map_any_to_table_rows_2.mapped:google_sheets_append_table_rows_v3_2.append","google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id:google_sheets_append_table_rows_v3_2.spreadsheet_id","google_sheets_append_table_rows_v3_2.appended:trigger_relay_1.relay","clone_file_v2_2.url:patch_json_v2_2.value","clone_file_v2_2.cloned:patch_json_v2_2.patch","patch_json_v2_2.data:patch_json_v2_1.data","patch_json_v2_2.patched:patch_json_v2_1.patch","patch_json_v2_1.data:map_any_to_table_rows_1.data","patch_json_v2_1.patched:map_any_to_table_rows_1.map","map_any_to_table_rows_1.rows:google_sheets_append_table_rows_v3_1.rows","map_any_to_table_rows_1.mapped:google_sheets_append_table_rows_v3_1.append","google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id:google_sheets_append_table_rows_v3_1.spreadsheet_id","google_sheets_append_table_rows_v3_1.appended:trigger_relay_1.relay","google_sheets_select_spreadsheet_id_v2_1.range:google_sheets_append_table_rows_v3_2.range","google_sheets_select_spreadsheet_id_v2_1.range:google_sheets_append_table_rows_v3_1.range","patch_json_v2_4.data:map_any_to_table_rows_2.data","patch_json_v2_4.patched:map_any_to_table_rows_2.map","fb_select_ad_account_id_v2_1.ad_account_id:fb_create_ad_image_v3_1.ad_account_id","data_relay_1.data:fb_create_ad_image_v3_1.url","fb_select_ad_account_id_v2_1.ad_account_id:fb_create_ad_video_v3_1.ad_account_id","data_relay_1.data:fb_create_ad_video_v3_1.url","fb_create_ad_video_v3_1.ad_video_id:patch_json_v2_3.data","fb_create_ad_image_v3_1.ad_image_id:patch_json_v2_2.data","post_integration_url_v2_1.body:extract_4.data","trigger_relay_1.relayed:for_each_v2_1.next","extract_4.data:data_relay_2.data","patch_json_v2_5.data:post_integration_url_v2_1.body","post_integration_url_v2_1.body:extract_3.data","extract_3.extracted:extract_4.extract","extract_3.data:data_relay_1.data","input_string_1.string:patch_json_v2_8.value","for_each_v2_1.item:patch_json_v2_5.value","fb_create_ad_video_v3_1.created:extract_2.extract","fb_create_ad_image_v3_1.created:extract_1.extract","google_sheets_fetch_table_rows_v3_1.rows:extract_list_1.data_list","google_sheets_fetch_table_rows_v3_1.fetched:extract_list_1.extract","start_1.start:google_sheets_fetch_table_rows_v3_1.fetch","google_sheets_select_spreadsheet_id_v2_1.range:google_sheets_fetch_table_rows_v3_1.range","extract_list_1.extracted:patch_json_v2_8.patch","for_each_v2_1.do:patch_json_v2_5.patch","google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id:google_sheets_fetch_table_rows_v3_1.spreadsheet_id","patch_json_v2_8.patched:patch_json_v2_7.patch","patch_json_v2_7.patched:post_integration_url_v2_2.post","patch_json_v2_8.data:patch_json_v2_7.data","patch_json_v2_7.data:post_integration_url_v2_2.body","input_boolean_1.boolean:patch_json_v2_7.value","concat_1.list:filter_v2_2.items","data_relay_2.data:fb_create_ad_video_v3_1.name","if_v2_2.false:if_v2_1.evaluate","if_v2_1.false:fb_create_ad_video_v3_1.create","data_relay_3.data:if_v2_2.b","if_v2_2.true:trigger_relay_2.relay","trigger_relay_2.relayed:fb_create_ad_image_v3_1.create","data_relay_2.data:data_relay_3.data","concat_1.done:filter_v2_2.filter","filter_v2_2.filtered:filter_v2_1.filter","filter_v2_2.items:filter_v2_1.items","data_relay_2.data:fb_create_ad_image_v3_1.name","data_relay_3.data:if_v2_1.b","if_v2_1.true:trigger_relay_2.relay","extract_4.extracted:if_v2_2.evaluate","filter_v2_1.items:extract_list_2.data_list","filter_v2_1.filtered:extract_list_2.extract","extract_list_2.data_list:calculate_set_operation_1.a","calculate_set_operation_1.data:parse_strings_to_ids_1.values","calculate_set_operation_1.calculated:parse_strings_to_ids_1.parse","parse_strings_to_ids_1.parsed:patch_json_list_v2_1.patch","join_data_1.items:filter_v2_3.items","filter_v2_3.filtered:for_each_v2_1.start","extract_list_1.data_list:calculate_set_operation_1.b","extract_list_2.extracted:calculate_set_operation_1.calculate","filter_v2_1.items:join_data_1.a","parse_strings_to_ids_1.result:patch_json_list_v2_1.data_list","patch_json_list_v2_1.data_list:join_data_1.b","patch_json_list_v2_1.patched:join_data_1.join","join_data_1.joined:filter_v2_3.filter","filter_v2_3.items:for_each_v2_1.items","data_relay_2.data:patch_json_v2_4.value","data_relay_2.data:patch_json_v2_1.value"],"groups":{"group_1":{"title":"Upload and add to Sheet","description":"","x":1736,"y":290,"inputs":["data_relay_1.data","data_relay_2.data","if_v2_2.evaluate"],"outputs":["trigger_relay_1.relayed","google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id","google_sheets_select_spreadsheet_id_v2_1.range"]},"group_7":{"title":"Dropbox API Request","description":"","x":401,"y":240,"inputs":["patch_json_v2_8.patch","input_string_1.string"],"outputs":["filter_v2_2.items","filter_v2_2.filtered"]},"group_2":{"title":"Clone to S3","description":"","x":1168,"y":860,"group":"group_1","inputs":["extract_1.extract","extract_1.data"],"outputs":["clone_file_v2_2.cloned","clone_file_v2_2.url"]},"group_3":{"title":"Map Rows","description":"","x":1507,"y":818,"group":"group_1","inputs":["patch_json_v2_1.value","patch_json_v2_2.value","patch_json_v2_2.data","patch_json_v2_2.patch"],"outputs":["map_any_to_table_rows_1.mapped","map_any_to_table_rows_1.rows"]},"group_4":{"title":"Clone to S3","description":"","x":1260,"y":444,"group":"group_1","inputs":["extract_2.data","extract_2.extract"],"outputs":["clone_file_v2_1.url","clone_file_v2_1.cloned"]},"group_6":{"title":"Get Temporary Link","description":"","x":1384,"y":293,"inputs":["patch_json_v2_5.value","patch_json_v2_5.patch"],"outputs":["extract_3.data","extract_4.extracted","extract_4.data"]},"group_8":{"title":"Get existing assets","description":"","x":122,"y":537,"inputs":["google_sheets_fetch_table_rows_v3_1.range","google_sheets_fetch_table_rows_v3_1.spreadsheet_id","google_sheets_fetch_table_rows_v3_1.fetch"],"outputs":["extract_list_1.data_list","extract_list_1.extracted"]},"group_9":{"title":"Skip uploaded items","description":"","x":723,"y":338,"inputs":["filter_v2_1.items","filter_v2_1.filter","calculate_set_operation_1.b"],"outputs":["filter_v2_3.items","filter_v2_3.filtered"]},"group_5":{"title":"Map Rows","description":"","x":1636,"y":415,"group":"group_1","inputs":["patch_json_v2_4.value","patch_json_v2_3.data","patch_json_v2_3.value","patch_json_v2_3.patch"],"outputs":["map_any_to_table_rows_2.rows","map_any_to_table_rows_2.mapped"]},"group_10":{"title":"Determine Ad Format","description":"","x":388,"y":515,"group":"group_1","inputs":["if_v2_2.evaluate","data_relay_3.data"],"outputs":["if_v2_1.false","trigger_relay_2.relayed"]},"group_11":{"title":"Modify data","description":"","x":1217,"y":717,"group":"group_9","inputs":["parse_strings_to_ids_1.values","parse_strings_to_ids_1.parse"],"outputs":["patch_json_list_v2_1.data_list","patch_json_list_v2_1.patched"]}},"widgets":{"widget_1":{"title":"Ad Account","description":"Select a Facebook Account.","position":0,"input":"fb_select_ad_account_id_v2_1.ad_account_id"},"widget_2":{"title":"Include Subfolders?","description":"Should subfolders be included or just files on the path specified above?","position":3,"icon":"las la-folder-open","options":[{"data":true,"title":"TRUE"},{"data":false,"title":"FALSE"}],"input":"input_boolean_1.boolean"},"widget_3":{"title":"Google Sheet","description":"The ids and names of your uploaded assets will be added here.","position":6,"icon":"","input":"google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id"},"widget_4":{"title":"Tab / Range","description":"The range in A1 notation.","position":7,"icon":"las la-table","input":"google_sheets_select_spreadsheet_id_v2_1.range"},"widget_5":{"title":"Dropbox Folder Path","description":"Add the path to your Dropbox folder starting with a forward slack (/).\nIf an asset with the same name already exists in the spreadsheet, it will be ignored.","position":2,"icon":"lab la-dropbox","input":"input_string_1.string"}},"variables":{},"config":{"capture_inputs_enabled":false,"caching_enabled":false},"tags":[]}

Auto-Upload Assets from Dropbox

{"name":"Auto-Upload new assets (Dropbox)","description":"upload_assets_dropbox_20230228","nodes":{"stop_1":{"type":"stop","logging_enabled":false,"x":1643,"y":792,"inputs":{"stop":{"export_enabled":true}}},"fb_select_ad_account_id_v2_1":{"type":"fb_select_ad_account_id_v2","logging_enabled":false,"x":211,"y":119,"group":"group_1","inputs":{"ad_account_id":{"export_enabled":true,"data":{"id":"1135934886600327","context":{"business":{"id":"999246123544891","name":"kitchn.io"},"ui":{"id":"act_1135934886600327","account_id":"1135934886600327","name":"Kitchn.io Demo Account","business":{"id":"999246123544891","name":"kitchn.io"}}},"provider":"facebook","type":"ad_account"}}}},"trigger_relay_1":{"type":"trigger_relay","logging_enabled":false,"x":2232,"y":769,"group":"group_1"},"data_relay_1":{"type":"data_relay","title":"Relay URL","description":"Relays data","logging_enabled":false,"x":84,"y":809,"group":"group_1","inputs":{"data":{"title":"  url","description":"Data to relay"}}},"google_sheets_select_spreadsheet_id_v2_1":{"type":"google_sheets_select_spreadsheet_id_v2","logging_enabled":false,"x":644,"y":86,"group":"group_1","inputs":{"spreadsheet_id":{"title":" spreadsheet_id","description":"The spreadsheet to fetch from"}}},"data_relay_2":{"type":"data_relay","title":"Relay Name","description":"Relays data","logging_enabled":false,"x":50,"y":506,"group":"group_1","inputs":{"data":{"title":"  name","description":"Data to relay"}}},"fb_create_ad_image_v3_1":{"type":"fb_create_ad_image_v3","logging_enabled":false,"x":836,"y":827,"group":"group_1"},"fb_create_ad_video_v3_1":{"type":"fb_create_ad_video_v3","logging_enabled":false,"x":817,"y":386,"group":"group_1"},"extract_1":{"type":"extract_v2","logging_enabled":false,"x":2086,"y":796,"group":"group_2","inputs":{"pointer":{"export_enabled":true,"data":"/context/image/url"}}},"patch_json_v2_1":{"type":"patch_json_v2","logging_enabled":false,"x":849,"y":231,"group":"group_3","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/context/asset_name","value":"{{input.value}}"}]}}},"patch_json_v2_2":{"type":"patch_json_v2","logging_enabled":false,"x":593,"y":197,"group":"group_3","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/context/image/url","value":"{{input.value}}"}]}}},"map_any_to_table_rows_1":{"type":"map_any_to_table_rows","logging_enabled":false,"x":1117,"y":227,"group":"group_3","inputs":{"add_header":{"export_enabled":true,"data":true},"mapping":{"export_enabled":true,"data":{"A":"/context/asset_name","B":"/type","C":"/context/image/hash","D":"/context/image/url"}},"schema":{"export_enabled":true,"data":"any"}}},"extract_2":{"type":"extract_v2","logging_enabled":false,"x":2082,"y":520,"group":"group_4","inputs":{"pointer":{"export_enabled":true,"data":"/context/thumbnail/uri"}}},"clone_file_v2_1":{"type":"clone_file_v2","logging_enabled":false,"x":2463,"y":301,"group":"group_4"},"map_any_to_table_rows_2":{"type":"map_any_to_table_rows","logging_enabled":false,"x":1483,"y":293,"group":"group_5","inputs":{"add_header":{"export_enabled":true,"data":true},"mapping":{"export_enabled":true,"data":{"A":"/context/asset_name","B":"/type","C":"/id","D":"/context/thumbnail/uri"}},"schema":{"export_enabled":true,"data":"any"}}},"patch_json_v2_3":{"type":"patch_json_v2","logging_enabled":false,"x":704,"y":267,"group":"group_5","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/context/thumbnail/uri","value":"{{input.value}}"}]}}},"clone_file_v2_2":{"type":"clone_file_v2","logging_enabled":false,"x":2480,"y":639,"group":"group_2"},"post_integration_url_v2_1":{"type":"post_integration_url_v2","logging_enabled":false,"x":934,"y":493,"group":"group_6","inputs":{"headers":{"export_enabled":true},"url":{"export_enabled":true,"data":"https://api.dropboxapi.com/2/files/get_temporary_link"},"provider":{"export_enabled":true,"data":"dropbox"}}},"post_integration_url_v2_2":{"type":"post_integration_url_v2","logging_enabled":false,"x":964,"y":382,"group":"group_7","inputs":{"headers":{"export_enabled":true},"url":{"export_enabled":true,"data":"https://api.dropboxapi.com/2/files/list_folder"},"provider":{"export_enabled":true,"data":"dropbox"}}},"google_sheets_append_table_rows_v3_1":{"type":"google_sheets_append_table_rows_v3","logging_enabled":false,"x":1877,"y":909,"group":"group_1"},"patch_json_v2_4":{"type":"patch_json_v2","logging_enabled":false,"x":975,"y":288,"group":"group_5","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/context/asset_name","value":"{{input.value}}"}]}}},"start_1":{"type":"start","logging_enabled":false,"x":50,"y":314},"for_each_v2_1":{"type":"for_each_v2","logging_enabled":false,"x":1807,"y":340},"extract_3":{"type":"extract_v2","logging_enabled":false,"x":1273,"y":564,"group":"group_6","inputs":{"pointer":{"export_enabled":true,"data":"/link"}},"outputs":{"data":{"title":"temp_file_link","description":"The extracted data"}}},"extract_4":{"type":"extract_v2","logging_enabled":false,"x":1622,"y":573,"group":"group_6","inputs":{"pointer":{"export_enabled":true,"data":"/metadata/name"}},"outputs":{"data":{"title":"file_name","description":"The extracted data"},"extracted":{"title":"extracted","description":"Triggers when the data was extracted"}}},"patch_json_v2_5":{"type":"patch_json_v2","logging_enabled":false,"x":496,"y":412,"group":"group_6","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/path","value":"{{input.value/path_lower}}"}]},"data":{"export_enabled":true,"data":{"path":""}}}},"google_sheets_fetch_table_rows_v3_1":{"type":"google_sheets_fetch_table_rows_v3","logging_enabled":false,"x":509,"y":284,"group":"group_8","inputs":{"date_time_render_option":{"export_enabled":true,"data":"FORMATTED_STRING"},"value_render_option":{"export_enabled":true,"data":"UNFORMATTED_VALUE"},"dimension":{"export_enabled":true,"data":"ROWS"}}},"extract_list_1":{"type":"extract_list","logging_enabled":false,"x":780,"y":406,"group":"group_8","inputs":{"pointer":{"export_enabled":true,"data":"/columns/0"}},"outputs":{"data_list":{"title":"existing_assets","description":"The extracted data"},"extracted":{"title":"extracted","description":"Triggers when the data was extracted"}}},"filter_v2_1":{"type":"filter_v2","logging_enabled":false,"x":309,"y":313,"group":"group_9","inputs":{"filters":{"export_enabled":true,"data":[{"value":"(.mp4|.m4v|.mov|.gif|.jpg|.jpeg|.png)","pointer":"/name","operator":"matches"}]}},"outputs":{"filtered":{"title":"filtered","description":"Triggered when filtered"}}},"google_sheets_append_table_rows_v3_2":{"type":"google_sheets_append_table_rows_v3","logging_enabled":false,"x":1916,"y":419,"group":"group_1"},"extract_5":{"type":"extract_v2","logging_enabled":false,"x":1259,"y":489,"group":"group_7","inputs":{"pointer":{"export_enabled":true,"data":"/entries"}},"outputs":{"extracted":{"title":"extracted","description":"Triggers when the data was extracted"}}},"extract_6":{"type":"extract_v2","logging_enabled":false,"x":2144,"y":423,"group":"group_7","inputs":{"pointer":{"export_enabled":true,"data":"/entries"}},"outputs":{"extracted":{"title":"extracted","description":"Triggers when the data was extracted"}}},"patch_json_v2_6":{"type":"patch_json_v2","logging_enabled":false,"x":1531,"y":340,"group":"group_7","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/cursor","value":"{{input.value/cursor}}"}]},"data":{"export_enabled":true,"data":{"cursor":""}}}},"post_integration_url_v2_3":{"type":"post_integration_url_v2","logging_enabled":false,"x":1844,"y":299,"group":"group_7","inputs":{"headers":{"export_enabled":true},"url":{"export_enabled":true,"data":"https://api.dropboxapi.com/2/files/list_folder/continue"},"provider":{"export_enabled":true,"data":"dropbox"}}},"concat_1":{"type":"concat","logging_enabled":false,"x":2463,"y":600,"group":"group_7","inputs":{"schema":{"export_enabled":true,"data":"any"}}},"patch_json_v2_7":{"type":"patch_json_v2","logging_enabled":false,"x":644,"y":357,"group":"group_7","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/recursive","value":"{{input.value}}"}]},"data":{"title":"body","description":"The data the patches are applied to"}}},"patch_json_v2_8":{"type":"patch_json_v2","logging_enabled":false,"x":320,"y":258,"group":"group_7","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/path","value":"{{input.value}}"}]},"data":{"title":"body","description":"The data the patches are applied to","export_enabled":true,"data":{"path":"","recursive":false,"limit":2000}}}},"input_string_1":{"type":"input_string","title":"Path","description":"Allows to input a string","logging_enabled":false,"max_job_retries":6,"timeout":30,"x":71,"y":275,"group":"group_7","inputs":{"string":{"title":"path","description":"A string to input","export_enabled":true,"data":"/creatives/2023/February"}}},"input_boolean_1":{"type":"input_boolean","logging_enabled":false,"x":356,"y":646,"group":"group_7","inputs":{"boolean":{"export_enabled":true,"data":true}}},"filter_v2_2":{"type":"filter_v2","logging_enabled":false,"x":2749,"y":655,"group":"group_7","inputs":{"filters":{"export_enabled":true,"data":[{"operator":"=","pointer":"/is_downloadable","value":true}]}}},"if_v2_1":{"type":"if_v2","logging_enabled":false,"x":1018,"y":514,"group":"group_10","inputs":{"a":{"export_enabled":true,"data":".png"},"condition":{"export_enabled":true,"data":"in"}},"outputs":{"false":{"title":"is_video","description":"Triggers when the evaluation is false"}}},"data_relay_3":{"type":"data_relay","logging_enabled":false,"x":292,"y":572,"group":"group_10","inputs":{"data":{"title":"name","description":"Data to relay"}}},"extract_list_2":{"type":"extract_list","logging_enabled":false,"x":638,"y":516,"group":"group_9","inputs":{"pointer":{"export_enabled":true,"data":"/name"}}},"if_v2_2":{"type":"if_v2","logging_enabled":false,"x":667,"y":317,"group":"group_10","inputs":{"a":{"export_enabled":true,"data":".jp"},"condition":{"export_enabled":true,"data":"in"}}},"trigger_relay_2":{"type":"trigger_relay","logging_enabled":false,"x":1408,"y":567,"group":"group_10","outputs":{"relayed":{"title":"is_image","description":"Output trigger from relay"}}},"filter_v2_3":{"type":"filter_v2","logging_enabled":false,"x":1867,"y":627,"group":"group_9","inputs":{"filters":{"export_enabled":true,"data":[{"operator":"!=","pointer":"/check","value":null}]}}},"join_data_1":{"type":"join_data","logging_enabled":false,"x":1556,"y":473,"group":"group_9","inputs":{"conditions":{"title":"conditions","description":"Conditions the lists get joined by","export_enabled":true,"data":[{"a":"/name","b":"/name"}]},"target":{"export_enabled":true,"data":"/check"}}},"calculate_set_operation_1":{"type":"calculate_set_operation","logging_enabled":false,"x":952,"y":665,"group":"group_9","inputs":{"operator":{"export_enabled":true,"data":"-"},"b":{"title":"b: existing_assets","description":"Set B"}}},"patch_json_list_v2_1":{"type":"patch_json_list_v2","logging_enabled":false,"x":1492,"y":709,"group":"group_11","inputs":{"patches":{"export_enabled":true,"data":[{"op":"move","path":"/name","from":"/id"},{"op":"remove","path":"/provider"},{"op":"remove","path":"/type"}]},"value":{"export_enabled":true}}},"parse_strings_to_ids_1":{"type":"parse_strings_to_ids","logging_enabled":false,"x":1224,"y":729,"group":"group_11","inputs":{"schema":{"export_enabled":true,"data":"snapchat_ad_account_id"}}},"calculate_math_operation_1":{"type":"calculate_math_operation","logging_enabled":false,"x":1461,"y":608,"group":"group_12","inputs":{"b":{"export_enabled":true,"data":300},"operator":{"export_enabled":true,"data":"-"}}},"data_relay_4":{"type":"data_relay","logging_enabled":false,"x":104,"y":473,"group":"group_12"},"timestamp_1":{"type":"timestamp","logging_enabled":false,"x":1197,"y":610,"group":"group_12"},"update_variable_1":{"type":"update_variable","logging_enabled":false,"x":1733,"y":604,"group":"group_12","inputs":{"name":{"export_enabled":true,"data":"last_run_ts"}}},"if_v2_3":{"type":"if_v2","logging_enabled":false,"x":2058,"y":399,"group":"group_12","inputs":{"b":{"export_enabled":true,"data":[]},"condition":{"export_enabled":true,"data":"not_equal"}},"outputs":{"true":{"title":"new_files","description":"Triggers when the evaluation is true"},"false":{"title":"no_new_files","description":"Triggers when the evaluation is false"}}},"fetch_variable_1":{"type":"fetch_variable","logging_enabled":false,"x":137,"y":177,"group":"group_12","inputs":{"name":{"export_enabled":true,"data":"last_run_ts"}}},"filter_v2_4":{"type":"filter_v2","logging_enabled":false,"x":928,"y":336,"group":"group_12"},"delay_1":{"type":"delay","logging_enabled":false,"x":167,"y":800,"inputs":{"duration":{"export_enabled":true,"data":900}}},"format_timestamp_v2_1":{"type":"format_timestamp_v2","logging_enabled":false,"x":389,"y":177,"group":"group_12","inputs":{"pattern":{"export_enabled":true,"data":"%Y-%m-%dT%H:%M:%SZ"}}},"google_sheets_select_spreadsheet_id_v2_2":{"type":"google_sheets_select_spreadsheet_id_v2","logging_enabled":false,"x":80,"y":503,"inputs":{"range":{"export_enabled":true,"data":"Assets"},"spreadsheet_id":{"export_enabled":true,"data":{"id":"1tym_BkhWQBQ4AXnMCSAJueuAxYO6bPkkO-xgu7giVMw","context":{"mime_type":"application/vnd.google-apps.spreadsheet","ui":{"id":"1tym_BkhWQBQ4AXnMCSAJueuAxYO6bPkkO-xgu7giVMw","name":"[Template] Facebook Bulk Ad Creation [Kitchn.io] [2022-12-17]","owners":[{"displayName":"Simon Kreienbaum","kind":"drive#user","me":true,"permissionId":"01137890803721275589","emailAddress":"simon@kitchn.io","photoLink":"https://lh3.googleusercontent.com/a-/ACB-R5SLBnYPQs1TuCD8FwP4oNtd689nkHASb6a8d2EZRIO4g3jLXH3ymyCMa0P_LB8jkmcCv7P-a76nsED4qYtBstlicKkioFoik8uEDD3T8CCxPrA0s8HsYSIzt8B5tj1uolSMZhl2GoNJTCbvVXWMcYnqU9F2O-_-u8560-jDdHI2ebQXlJXzzCWWHrkwpM3X5nk1NokxvSBl-u9Zyh78Yp49p1BjmDb_2Uamn-uPWLxpWna4g9p3nc437uJKm412VLF110-cfq_C96X37u2vLQKQxDSUl0UxR6WBOtYJVEW1g4OgF_zS_36Qop3M0s9lBxI1FpEfheXa4p-JMN57qDVhz8WRaKMLpIs9OT7AJ1Yk20PB8WXyRGPjCKgwOoZtVD5qfd2yQQJu0Tyy0a7pSkDLE_zZ-jTM6kP2gKpXMDJ-QjVk7xa7bIt_Zzvy_4o81sCa9TJu9P9BIqveYMJcrdyX3biBW7uEScBuCy-3bOFNIp0Uu2jkoa3suRAxLIb7WXoeem6rqrwKMAsR4YeMm4tgb-Qy7NfWgCgaAWQiMQvBVMUUWcnYzV4ojkcYqGMuUHoJOqlPXuWQFU_uxuXr8FsLAsDoT9rVj4LXpijFSBIQ1eqfkAI_YO-1cz-YnHKSz1iZU_8jbDCpjqg-gxJQyUIjjIB4VNyu1S5wq8iFjtMqhzXSJS3GK0bnjzhuPdmhbRmnfp9bqUqo_A1ITodEzfHGtjvZeqH5RfMll3_NdYI6YNFPY7T_WBSIsOzMLr8Aqt5ODLSQKOF50QpzKviPpvURbox52Pltc9NyTyroMWqA8jpHLcswKLELaUNOX55imuhINyinMBhMYQHYS8K4g7JhbaKiJnKNGZLs6l853KJtnAR88iIjiz6ysJ96HOP3N4zdqtdyhY_WZIpnsBHz58oNnJiGFDcqm7LjrUhu15mQi0p5raFNI4xk5vv4=s64"}],"mime_type":"application/vnd.google-apps.spreadsheet"}},"provider":"google_drive","type":"file"}}}},"patch_json_v2_9":{"type":"patch_json_v2","logging_enabled":false,"x":642,"y":178,"group":"group_12","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/0/value","value":"{{input.value}}"}]},"data":{"export_enabled":true,"data":[{"operator":"\u003e=","pointer":"/client_modified","value":"2023-02-28T10:28:50Z"}]}}}},"edges":["post_integration_url_v2_2.body:extract_5.data","patch_json_v2_6.patched:post_integration_url_v2_3.post","post_integration_url_v2_3.body:extract_6.data","post_integration_url_v2_2.posted:extract_5.extract","post_integration_url_v2_2.body:patch_json_v2_6.value","post_integration_url_v2_3.posted:extract_6.extract","patch_json_v2_6.data:post_integration_url_v2_3.body","extract_6.extracted:concat_1.concat","extract_6.data:concat_1.a","extract_5.data:concat_1.b","extract_5.extracted:patch_json_v2_6.patch","post_integration_url_v2_1.posted:extract_3.extract","patch_json_v2_5.patched:post_integration_url_v2_1.post","extract_2.data:clone_file_v2_1.url","extract_2.extracted:clone_file_v2_1.clone","extract_1.data:clone_file_v2_2.url","extract_1.extracted:clone_file_v2_2.clone","fb_create_ad_video_v3_1.ad_video_id:extract_2.data","fb_create_ad_image_v3_1.ad_image_id:extract_1.data","clone_file_v2_1.url:patch_json_v2_3.value","clone_file_v2_1.cloned:patch_json_v2_3.patch","patch_json_v2_3.data:patch_json_v2_4.data","patch_json_v2_3.patched:patch_json_v2_4.patch","map_any_to_table_rows_2.rows:google_sheets_append_table_rows_v3_2.rows","map_any_to_table_rows_2.mapped:google_sheets_append_table_rows_v3_2.append","google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id:google_sheets_append_table_rows_v3_2.spreadsheet_id","google_sheets_append_table_rows_v3_2.appended:trigger_relay_1.relay","clone_file_v2_2.url:patch_json_v2_2.value","clone_file_v2_2.cloned:patch_json_v2_2.patch","patch_json_v2_2.data:patch_json_v2_1.data","patch_json_v2_2.patched:patch_json_v2_1.patch","patch_json_v2_1.data:map_any_to_table_rows_1.data","patch_json_v2_1.patched:map_any_to_table_rows_1.map","map_any_to_table_rows_1.rows:google_sheets_append_table_rows_v3_1.rows","map_any_to_table_rows_1.mapped:google_sheets_append_table_rows_v3_1.append","google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id:google_sheets_append_table_rows_v3_1.spreadsheet_id","google_sheets_append_table_rows_v3_1.appended:trigger_relay_1.relay","google_sheets_select_spreadsheet_id_v2_1.range:google_sheets_append_table_rows_v3_2.range","google_sheets_select_spreadsheet_id_v2_1.range:google_sheets_append_table_rows_v3_1.range","patch_json_v2_4.data:map_any_to_table_rows_2.data","patch_json_v2_4.patched:map_any_to_table_rows_2.map","fb_select_ad_account_id_v2_1.ad_account_id:fb_create_ad_image_v3_1.ad_account_id","data_relay_1.data:fb_create_ad_image_v3_1.url","fb_select_ad_account_id_v2_1.ad_account_id:fb_create_ad_video_v3_1.ad_account_id","data_relay_1.data:fb_create_ad_video_v3_1.url","fb_create_ad_video_v3_1.ad_video_id:patch_json_v2_3.data","fb_create_ad_image_v3_1.ad_image_id:patch_json_v2_2.data","post_integration_url_v2_1.body:extract_4.data","trigger_relay_1.relayed:for_each_v2_1.next","extract_4.data:data_relay_2.data","patch_json_v2_5.data:post_integration_url_v2_1.body","post_integration_url_v2_1.body:extract_3.data","extract_3.extracted:extract_4.extract","extract_3.data:data_relay_1.data","input_string_1.string:patch_json_v2_8.value","for_each_v2_1.item:patch_json_v2_5.value","fb_create_ad_video_v3_1.created:extract_2.extract","fb_create_ad_image_v3_1.created:extract_1.extract","google_sheets_fetch_table_rows_v3_1.rows:extract_list_1.data_list","google_sheets_fetch_table_rows_v3_1.fetched:extract_list_1.extract","for_each_v2_1.do:patch_json_v2_5.patch","patch_json_v2_8.patched:patch_json_v2_7.patch","patch_json_v2_7.patched:post_integration_url_v2_2.post","patch_json_v2_8.data:patch_json_v2_7.data","patch_json_v2_7.data:post_integration_url_v2_2.body","input_boolean_1.boolean:patch_json_v2_7.value","concat_1.list:filter_v2_2.items","data_relay_2.data:fb_create_ad_video_v3_1.name","if_v2_2.false:if_v2_1.evaluate","if_v2_1.false:fb_create_ad_video_v3_1.create","data_relay_3.data:if_v2_2.b","if_v2_2.true:trigger_relay_2.relay","trigger_relay_2.relayed:fb_create_ad_image_v3_1.create","data_relay_2.data:data_relay_3.data","concat_1.done:filter_v2_2.filter","data_relay_2.data:fb_create_ad_image_v3_1.name","data_relay_3.data:if_v2_1.b","if_v2_1.true:trigger_relay_2.relay","extract_4.extracted:if_v2_2.evaluate","filter_v2_1.items:extract_list_2.data_list","filter_v2_1.filtered:extract_list_2.extract","extract_list_2.data_list:calculate_set_operation_1.a","calculate_set_operation_1.data:parse_strings_to_ids_1.values","calculate_set_operation_1.calculated:parse_strings_to_ids_1.parse","parse_strings_to_ids_1.parsed:patch_json_list_v2_1.patch","join_data_1.items:filter_v2_3.items","filter_v2_3.filtered:for_each_v2_1.start","extract_list_1.data_list:calculate_set_operation_1.b","extract_list_2.extracted:calculate_set_operation_1.calculate","filter_v2_1.items:join_data_1.a","parse_strings_to_ids_1.result:patch_json_list_v2_1.data_list","patch_json_list_v2_1.data_list:join_data_1.b","patch_json_list_v2_1.patched:join_data_1.join","join_data_1.joined:filter_v2_3.filter","filter_v2_3.items:for_each_v2_1.items","filter_v2_2.items:data_relay_4.data","timestamp_1.timestamp:calculate_math_operation_1.a","calculate_math_operation_1.data:update_variable_1.data","timestamp_1.done:calculate_math_operation_1.calculate","calculate_math_operation_1.calculated:update_variable_1.update","fetch_variable_1.data:format_timestamp_v2_1.timestamp","format_timestamp_v2_1.formatted:patch_json_v2_9.patch","patch_json_v2_9.patched:filter_v2_4.filter","if_v2_3.false:delay_1.start","data_relay_4.data:filter_v2_4.items","fetch_variable_1.fetched:format_timestamp_v2_1.format","format_timestamp_v2_1.date_time:patch_json_v2_9.value","patch_json_v2_9.data:filter_v2_4.filters","filter_v2_4.filtered:timestamp_1.now","filter_v2_4.items:filter_v2_1.items","filter_v2_2.filtered:fetch_variable_1.fetch","for_each_v2_1.done:delay_1.start","google_sheets_select_spreadsheet_id_v2_2.spreadsheet_id:google_sheets_fetch_table_rows_v3_1.spreadsheet_id","google_sheets_select_spreadsheet_id_v2_2.range:google_sheets_select_spreadsheet_id_v2_1.range","google_sheets_select_spreadsheet_id_v2_2.range:google_sheets_fetch_table_rows_v3_1.range","google_sheets_select_spreadsheet_id_v2_2.spreadsheet_id:google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id","filter_v2_4.items:if_v2_3.a","update_variable_1.updated:if_v2_3.evaluate","extract_list_1.extracted:filter_v2_1.filter","data_relay_2.data:patch_json_v2_1.value","data_relay_2.data:patch_json_v2_4.value","start_1.start:patch_json_v2_8.patch","if_v2_3.true:google_sheets_fetch_table_rows_v3_1.fetch","delay_1.delayed:patch_json_v2_8.patch"],"groups":{"group_1":{"title":"Upload and add to Sheet","description":"","x":2556,"y":535,"inputs":["data_relay_1.data","google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id","data_relay_2.data","if_v2_2.evaluate","google_sheets_select_spreadsheet_id_v2_1.range"],"outputs":["trigger_relay_1.relayed"]},"group_7":{"title":"Dropbox API Request","description":"","x":448,"y":253,"inputs":["patch_json_v2_8.patch","input_string_1.string"],"outputs":["filter_v2_2.items","filter_v2_2.filtered"]},"group_6":{"title":"Get Temporary Link","description":"","x":2163,"y":395,"inputs":["patch_json_v2_5.value","patch_json_v2_5.patch"],"outputs":["extract_3.data","extract_4.extracted","extract_4.data"]},"group_8":{"title":"Get existing assets","description":"","x":1107,"y":427,"inputs":["google_sheets_fetch_table_rows_v3_1.range","google_sheets_fetch_table_rows_v3_1.spreadsheet_id","google_sheets_fetch_table_rows_v3_1.fetch"],"outputs":["extract_list_1.data_list","extract_list_1.extracted"]},"group_9":{"title":"Skip uploaded items","description":"","x":1454,"y":284,"inputs":["filter_v2_1.items","filter_v2_1.filter","calculate_set_operation_1.b"],"outputs":["filter_v2_3.items","filter_v2_3.filtered"]},"group_2":{"title":"Clone to S3","description":"","x":1168,"y":860,"group":"group_1","inputs":["extract_1.extract","extract_1.data"],"outputs":["clone_file_v2_2.cloned","clone_file_v2_2.url"]},"group_3":{"title":"Map Rows","description":"","x":1507,"y":818,"group":"group_1","inputs":["patch_json_v2_1.value","patch_json_v2_2.value","patch_json_v2_2.data","patch_json_v2_2.patch"],"outputs":["map_any_to_table_rows_1.mapped","map_any_to_table_rows_1.rows"]},"group_4":{"title":"Clone to S3","description":"","x":1260,"y":444,"group":"group_1","inputs":["extract_2.data","extract_2.extract"],"outputs":["clone_file_v2_1.url","clone_file_v2_1.cloned"]},"group_5":{"title":"Map Rows","description":"","x":1636,"y":415,"group":"group_1","inputs":["patch_json_v2_4.value","patch_json_v2_3.data","patch_json_v2_3.value","patch_json_v2_3.patch"],"outputs":["map_any_to_table_rows_2.rows","map_any_to_table_rows_2.mapped"]},"group_10":{"title":"Determine Ad Format","description":"","x":388,"y":515,"group":"group_1","inputs":["if_v2_2.evaluate","data_relay_3.data"],"outputs":["if_v2_1.false","trigger_relay_2.relayed"]},"group_11":{"title":"Modify data","description":"","x":1217,"y":717,"group":"group_9","inputs":["parse_strings_to_ids_1.values","parse_strings_to_ids_1.parse"],"outputs":["patch_json_list_v2_1.data_list","patch_json_list_v2_1.patched"]},"group_12":{"title":"Get only most recent items","description":"","x":781,"y":288,"inputs":["data_relay_4.data","fetch_variable_1.fetch"],"outputs":["filter_v2_4.items","if_v2_3.true","if_v2_3.false"]}},"widgets":{"widget_1":{"title":"Ad Account","description":"Select a Facebook Account.","position":0,"input":"fb_select_ad_account_id_v2_1.ad_account_id"},"widget_2":{"title":"Include Subfolders?","description":"Should subfolders be included or just files on the path specified above?","position":3,"icon":"las la-folder-open","options":[{"data":true,"title":"TRUE"},{"data":false,"title":"FALSE"}],"input":"input_boolean_1.boolean"},"widget_3":{"title":"Dropbox Folder Path","description":"Add the path to your Dropbox folder starting with a forward slack (/).\nIf an asset with the same name already exists in the spreadsheet, it will be ignored.","position":2,"icon":"lab la-dropbox","input":"input_string_1.string"},"widget_4":{"title":"Google Sheet","description":"The ids and names of your uploaded assets will be added here.","position":6,"icon":"","input":"google_sheets_select_spreadsheet_id_v2_2.spreadsheet_id"},"widget_5":{"title":"Tab / Range","description":"The range in A1 notation.","position":7,"icon":"las la-table","input":"google_sheets_select_spreadsheet_id_v2_2.range"},"widget_6":{"title":"Run Every","description":"Check for new files every __ minutes.","position":99,"icon":"las la-clock","input":"delay_1.duration"}},"variables":{"variable_1":{"name":"last_run_ts","data":1677542400}},"config":{"capture_inputs_enabled":false,"caching_enabled":false},"tags":[]}