Automatically upload new assets (GDrive → Facebook)
This automation should be used in conjunction with the Bulk Ads Uploading use case. Instead of manually choosing from which folder to upload new files, use this automation to automatically upload new files as soon as they are added.
JSON Recipe
Import the automation recipe(s) into your own account. Don’t know how? Learn here.
{"name":"Automatically upload new assets (GDrive)","description":"upload_assets_gdrive_20230208","nodes":{"delay_1":{"type":"delay","logging_enabled":false,"x":722,"y":768,"inputs":{"duration":{"export_enabled":true,"data":1800}}},"stop_1":{"type":"stop","logging_enabled":false,"x":1109,"y":929,"inputs":{"stop":{"export_enabled":true}}},"google_sheets_fetch_table_rows_v3_1":{"type":"google_sheets_fetch_table_rows_v3","logging_enabled":false,"x":509,"y":283,"group":"group_1","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_1","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"}}},"start_1":{"type":"start","logging_enabled":false,"x":8,"y":484},"delete_file_1":{"type":"delete_file","logging_enabled":false,"x":1196,"y":471,"group":"group_2"},"extract_1":{"type":"extract_v2","logging_enabled":false,"x":379,"y":333,"group":"group_3","inputs":{"pointer":{"export_enabled":true,"data":"/id"}}},"google_drive_download_file_1":{"type":"google_drive_download_file","logging_enabled":false,"x":1075,"y":441,"group":"group_3"},"parse_string_to_id_1":{"type":"parse_string_to_id","logging_enabled":false,"x":735,"y":372,"group":"group_3","inputs":{"schema":{"export_enabled":true,"data":"google_drive_folder_id"}}},"google_sheets_select_spreadsheet_id_v2_1":{"type":"google_sheets_select_spreadsheet_id_v2","logging_enabled":false,"x":112,"y":58,"inputs":{"range":{"export_enabled":true,"data":"Assets"},"spreadsheet_id":{"title":"spreadsheet_id","description":"The spreadsheet to fetch from"}}},"if_v2_1":{"type":"if_v2","logging_enabled":false,"x":500,"y":286,"group":"group_4","inputs":{"condition":{"export_enabled":true,"data":"equal"},"a":{"export_enabled":true,"data":"skip"}}},"data_relay_1":{"type":"data_relay","logging_enabled":false,"x":79,"y":218,"group":"group_2","inputs":{"data":{"title":"file","description":"Data to relay"}}},"input_string_1":{"type":"input_string","logging_enabled":false,"x":136,"y":573,"group":"group_4","inputs":{"string":{"title":"skip?","description":"A string to input","export_enabled":true,"data":"skip"}}},"if_v2_2":{"type":"if_v2","logging_enabled":false,"x":1441,"y":232,"group":"group_4","inputs":{"b":{"title":"existing_assets","description":"Write or paste the data B"},"condition":{"export_enabled":true,"data":"not_in"}},"outputs":{"false":{"title":"skip","description":"Triggers when the evaluation is false"}}},"patch_json_v2_1":{"type":"patch_json_v2","logging_enabled":false,"x":1413,"y":240,"group":"group_5","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/timestamp","value":"{{input.value}}"}]}}},"format_timestamp_v2_1":{"type":"format_timestamp_v2","logging_enabled":false,"x":1021,"y":234,"group":"group_6","inputs":{"pattern":{"export_enabled":true,"data":"%Y-%m-%dT%H:%M:%S%z"}}},"timestamp_1":{"type":"timestamp","logging_enabled":false,"x":733,"y":221,"group":"group_6"},"format_timestamp_v2_2":{"type":"format_timestamp_v2","logging_enabled":false,"x":1096,"y":222,"group":"group_5","inputs":{"pattern":{"export_enabled":true,"data":"%Y-%m-%dT%H:%M:%S%z"}}},"fb_select_ad_account_id_v2_1":{"type":"fb_select_ad_account_id_v2","logging_enabled":false,"x":418,"y":139,"group":"group_2","inputs":{"ad_account_id":{"title":"ad_account_id","description":"Select a Facebook Account"}}},"trigger_relay_1":{"type":"trigger_relay","logging_enabled":false,"x":1873,"y":560,"group":"group_4","outputs":{"relayed":{"title":"upload","description":"Output trigger from relay"}}},"extract_2":{"type":"extract_v2","logging_enabled":false,"x":817,"y":217,"group":"group_4","inputs":{"pointer":{"export_enabled":true,"data":"/name"}}},"fb_create_ad_video_v3_1":{"type":"fb_create_ad_video_v3","logging_enabled":false,"x":653,"y":304,"group":"group_7"},"fb_select_ad_account_id_v2_2":{"type":"fb_select_ad_account_id_v2","title":"Relay Facebook Ad Account Id","description":"Select one id of your connected Ad Accounts.","logging_enabled":false,"x":2,"y":278,"group":"group_7","inputs":{"ad_account_id":{"title":"ad_account_id","description":"Select a Facebook Account"}}},"google_sheets_append_table_rows_v3_1":{"type":"google_sheets_append_table_rows_v3","logging_enabled":false,"x":1603,"y":681,"group":"group_7"},"google_sheets_append_table_rows_v3_2":{"type":"google_sheets_append_table_rows_v3","logging_enabled":false,"x":1615,"y":328,"group":"group_7"},"trigger_relay_2":{"type":"trigger_relay","logging_enabled":false,"x":1994,"y":564,"group":"group_7"},"data_relay_2":{"type":"data_relay","logging_enabled":false,"x":310,"y":210,"group":"group_7","inputs":{"data":{"title":"url","description":"Data to relay"}}},"google_sheets_select_spreadsheet_id_v2_2":{"type":"google_sheets_select_spreadsheet_id_v2","logging_enabled":false,"x":1083,"y":45,"group":"group_7","inputs":{"range":{"title":" range","description":"The range in A1 notation to fetch"},"spreadsheet_id":{"title":" spreadsheet_id","description":"The spreadsheet to fetch from"}}},"fb_create_ad_image_v3_1":{"type":"fb_create_ad_image_v3","logging_enabled":false,"x":679,"y":622,"group":"group_7"},"extract_3":{"type":"extract_v2","logging_enabled":false,"x":1890,"y":673,"group":"group_8","inputs":{"pointer":{"export_enabled":true,"data":"/context/image/url"}}},"clone_file_v2_1":{"type":"clone_file_v2","logging_enabled":false,"x":2480,"y":638,"group":"group_8"},"patch_json_v2_2":{"type":"patch_json_v2","logging_enabled":false,"x":464,"y":222,"group":"group_6","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/context/asset_name","value":"{{input.value}}"}]}}},"patch_json_v2_3":{"type":"patch_json_v2","logging_enabled":false,"x":108,"y":171,"group":"group_6","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":1560,"y":235,"group":"group_6","inputs":{"add_header":{"export_enabled":true,"data":false},"mapping":{"export_enabled":true,"data":{"A":"/context/asset_name","B":"/type","C":"/context/image/hash","D":"/context/image/url","E":"/timestamp"}},"schema":{"export_enabled":true,"data":"any"}}},"if_v2_3":{"type":"if_v2","logging_enabled":false,"x":1070,"y":421,"group":"group_9","inputs":{"b":{"export_enabled":true,"data":["video/mp4","image/gif","application/vnd.google-apps.video","video/x-flv","video/MP2T","video/3gpp","video/quicktime","video/x-msvideo","video/x-ms-wmv"]},"condition":{"export_enabled":true,"data":"in"}},"outputs":{"false":{"title":"is_image","description":"Triggers when the evaluation is false"},"true":{"title":"is_video","description":"Triggers when the evaluation is true"}}},"extract_4":{"type":"extract_v2","logging_enabled":false,"x":698,"y":374,"group":"group_9","inputs":{"pointer":{"export_enabled":true,"data":"/mimeType"}},"outputs":{"data":{"title":"mimeType","description":"The extracted data"}}},"data_relay_3":{"type":"data_relay","logging_enabled":false,"x":286,"y":383,"group":"group_9","inputs":{"data":{"title":"file","description":"Data to relay"}}},"extract_5":{"type":"extract_v2","logging_enabled":false,"x":1857,"y":379,"group":"group_10","inputs":{"pointer":{"export_enabled":true,"data":"/context/thumbnail/uri"}}},"clone_file_v2_2":{"type":"clone_file_v2","logging_enabled":false,"x":2463,"y":301,"group":"group_10"},"patch_json_v2_4":{"type":"patch_json_v2","logging_enabled":false,"x":527,"y":187,"group":"group_5","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/context/asset_name","value":"{{input.value}}"}]}}},"patch_json_v2_5":{"type":"patch_json_v2","logging_enabled":false,"x":173,"y":155,"group":"group_5","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/context/thumbnail/uri","value":"{{input.value}}"}]}}},"map_any_to_table_rows_2":{"type":"map_any_to_table_rows","logging_enabled":false,"x":1722,"y":238,"group":"group_5","inputs":{"add_header":{"export_enabled":true,"data":false},"mapping":{"export_enabled":true,"data":{"A":"/context/asset_name","B":"/type","C":"/id","D":"/context/thumbnail/uri","E":"/timestamp"}},"schema":{"export_enabled":true,"data":"any"}}},"replace_string_1":{"type":"replace_string","logging_enabled":false,"x":1124,"y":245,"group":"group_4","inputs":{"value":{"export_enabled":true,"data":""},"regex":{"title":"regex (paste here)","description":"Regex for replacing the string","export_enabled":true,"data":""},"pointer":{"export_enabled":true,"data":""},"schema":{"export_enabled":true}},"outputs":{"data":{"title":"name","description":"Data that has been partially replaced"}}},"data_relay_4":{"type":"data_relay","logging_enabled":false,"x":138,"y":737,"group":"group_7","inputs":{"data":{"title":"name","description":"Data to relay"}}},"timestamp_2":{"type":"timestamp","logging_enabled":false,"x":790,"y":239,"group":"group_5"},"patch_json_v2_6":{"type":"patch_json_v2","logging_enabled":false,"x":1312,"y":230,"group":"group_6","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/timestamp","value":"{{input.value}}"}]}}},"input_any_1":{"type":"input_any","title":"No file endings?Copy to \"regex\" below","description":"Allows to input a any type","logging_enabled":false,"max_job_retries":6,"timeout":30,"x":1121,"y":72,"group":"group_4","inputs":{"any":{"title":"regex (copy me)","description":"Copy this field into the regex field below to remove file endings from your assets. Add any further file endings with the pipe symbol | and the file ending.","export_enabled":true,"data":"\\.(png|mp4|jpg|jpeg|gif|mov|bmp)"}},"outputs":{"any":{"title":" ","description":"The any to input"}}},"for_each_v2_1":{"type":"for_each_v2","title":"For Each File","description":"Loops over elements in a list","logging_enabled":false,"max_job_retries":6,"timeout":30,"x":783,"y":277,"inputs":{"start":{"title":" start","description":"Starts the first iteration"}}},"timestamp_3":{"type":"timestamp","logging_enabled":false,"x":1228,"y":667,"group":"group_11","inputs":{"now":{"title":"now","description":"Gets the current unix timestamp"}}},"patch_json_v2_7":{"type":"patch_json_v2","logging_enabled":false,"x":664,"y":264,"group":"group_11","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/0/value","value":"{{input.value}}"}]},"data":{"export_enabled":true,"data":[{"operator":"\u003e=","pointer":"/createdTime","value":1672398442}]}}},"google_drive_select_folder_id_1":{"type":"google_drive_select_folder_id","logging_enabled":false,"x":534,"y":96,"group":"group_11","inputs":{"folder_id":{"title":"folder_id","description":"Select one folder to use as source"}}},"input_boolean_1":{"type":"input_boolean","title":"Include Subfolders?","description":"Allows to input a boolean type","logging_enabled":false,"max_job_retries":6,"timeout":30,"x":485,"y":702,"group":"group_11","inputs":{"boolean":{"export_enabled":true,"data":true}}},"google_drive_fetch_files_v2_1":{"type":"google_drive_fetch_files_v2","logging_enabled":false,"x":1465,"y":401,"group":"group_11","inputs":{"mime_types":{"export_enabled":true,"data":["image/jpeg","image/png","image/gif","image/bmp","video/x-flv","video/mp4","application/x-mpegURL","video/MP2T","video/3gpp","video/quicktime","video/x-ms-wmv","video/x-msvideo","application/vnd.google-apps.video","application/vnd.google-apps.photo"]},"parent_folder_id":{"title":"parent_folder_id","description":"Select a folder where all the files you want to fetch are"}}},"patch_json_v2_8":{"type":"patch_json_v2","logging_enabled":false,"x":949,"y":327,"group":"group_11","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/0/value","value":"{{input.value}}"}]},"data":{"export_enabled":true,"data":[{"operator":"\u003e=","pointer":"/modifiedTime","value":1672398442}]}}},"update_variable_1":{"type":"update_variable","logging_enabled":false,"x":1489,"y":730,"group":"group_11","inputs":{"name":{"export_enabled":true,"data":"timestamp"}}},"join_1":{"type":"join","logging_enabled":false,"x":1887,"y":426,"group":"group_11"},"google_drive_fetch_files_v2_2":{"type":"google_drive_fetch_files_v2","logging_enabled":false,"x":1425,"y":46,"group":"group_11","inputs":{"mime_types":{"export_enabled":true,"data":["image/jpeg","image/png","image/gif","image/bmp","video/x-flv","video/mp4","application/x-mpegURL","video/MP2T","video/3gpp","video/quicktime","video/x-ms-wmv","video/x-msvideo","application/vnd.google-apps.video","application/vnd.google-apps.photo"]},"parent_folder_id":{"title":"parent_folder_id","description":"Select a folder where all the files you want to fetch are"}}},"concat_1":{"type":"concat","logging_enabled":false,"x":2124,"y":154,"group":"group_11","inputs":{"schema":{"export_enabled":true,"data":"google_drive_file"}}},"fetch_variable_1":{"type":"fetch_variable","logging_enabled":false,"x":238,"y":386,"group":"group_11","inputs":{"name":{"export_enabled":true,"data":"timestamp"}}}},"edges":["google_sheets_fetch_table_rows_v3_1.rows:extract_list_1.data_list","start_1.start:google_sheets_fetch_table_rows_v3_1.fetch","extract_list_1.data_list:if_v2_2.b","google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id:google_sheets_fetch_table_rows_v3_1.spreadsheet_id","google_sheets_select_spreadsheet_id_v2_1.range:google_sheets_fetch_table_rows_v3_1.range","google_sheets_fetch_table_rows_v3_1.fetched:extract_list_1.extract","for_each_v2_1.item:extract_2.data","for_each_v2_1.do:if_v2_1.evaluate","if_v2_1.true:extract_2.extract","input_string_1.string:if_v2_1.b","google_drive_download_file_1.url:data_relay_2.data","data_relay_2.data:fb_create_ad_video_v3_1.url","data_relay_2.data:fb_create_ad_image_v3_1.url","extract_3.extracted:clone_file_v2_1.clone","fb_create_ad_image_v3_1.ad_image_id:extract_3.data","extract_5.extracted:clone_file_v2_2.clone","extract_3.data:clone_file_v2_1.url","extract_5.data:clone_file_v2_2.url","fb_create_ad_video_v3_1.ad_video_id:extract_5.data","clone_file_v2_2.url:patch_json_v2_5.value","clone_file_v2_2.cloned:patch_json_v2_5.patch","patch_json_v2_5.data:patch_json_v2_4.data","patch_json_v2_5.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_2.spreadsheet_id:google_sheets_append_table_rows_v3_2.spreadsheet_id","google_sheets_append_table_rows_v3_2.appended:trigger_relay_2.relay","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_2.data","patch_json_v2_3.patched:patch_json_v2_2.patch","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_2.spreadsheet_id:google_sheets_append_table_rows_v3_1.spreadsheet_id","google_sheets_append_table_rows_v3_1.appended:trigger_relay_2.relay","google_sheets_select_spreadsheet_id_v2_2.range:google_sheets_append_table_rows_v3_2.range","google_sheets_select_spreadsheet_id_v2_2.range:google_sheets_append_table_rows_v3_1.range","fb_create_ad_image_v3_1.ad_image_id:patch_json_v2_3.data","fb_select_ad_account_id_v2_2.ad_account_id:fb_create_ad_image_v3_1.ad_account_id","fb_select_ad_account_id_v2_2.ad_account_id:fb_create_ad_video_v3_1.ad_account_id","fb_create_ad_video_v3_1.ad_video_id:patch_json_v2_5.data","fb_create_ad_video_v3_1.created:extract_5.extract","fb_create_ad_image_v3_1.created:extract_3.extract","if_v2_2.true:trigger_relay_1.relay","if_v2_1.false:trigger_relay_1.relay","patch_json_v2_4.patched:timestamp_2.now","patch_json_v2_1.data:map_any_to_table_rows_2.data","format_timestamp_v2_1.date_time:patch_json_v2_6.value","format_timestamp_v2_1.formatted:patch_json_v2_6.patch","timestamp_1.timestamp:format_timestamp_v2_1.timestamp","data_relay_1.data:data_relay_3.data","trigger_relay_1.relayed:extract_1.extract","google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id:google_sheets_select_spreadsheet_id_v2_2.spreadsheet_id","for_each_v2_1.item:data_relay_1.data","delete_file_1.deleted:for_each_v2_1.next","replace_string_1.data:if_v2_2.a","data_relay_4.data:fb_create_ad_video_v3_1.name","data_relay_4.data:patch_json_v2_2.value","data_relay_3.data:extract_4.data","extract_4.extracted:if_v2_3.evaluate","extract_4.data:if_v2_3.a","if_v2_3.true:fb_create_ad_video_v3_1.create","if_v2_3.false:fb_create_ad_image_v3_1.create","extract_1.data:parse_string_to_id_1.value","extract_1.extracted:parse_string_to_id_1.parse","parse_string_to_id_1.result:google_drive_download_file_1.file_id","parse_string_to_id_1.parsed:google_drive_download_file_1.download","google_drive_download_file_1.url:delete_file_1.url","data_relay_1.data:extract_1.data","google_sheets_select_spreadsheet_id_v2_1.range:google_sheets_select_spreadsheet_id_v2_2.range","if_v2_2.false:for_each_v2_1.next","extract_2.data:replace_string_1.data","replace_string_1.replaced:if_v2_2.evaluate","data_relay_4.data:fb_create_ad_image_v3_1.name","replace_string_1.data:data_relay_4.data","data_relay_4.data:patch_json_v2_4.value","format_timestamp_v2_2.date_time:patch_json_v2_1.value","format_timestamp_v2_2.formatted:patch_json_v2_1.patch","timestamp_2.timestamp:format_timestamp_v2_2.timestamp","timestamp_2.done:format_timestamp_v2_2.format","patch_json_v2_4.data:patch_json_v2_1.data","patch_json_v2_1.patched:map_any_to_table_rows_2.map","patch_json_v2_2.patched:timestamp_1.now","patch_json_v2_6.patched:map_any_to_table_rows_1.map","google_drive_download_file_1.downloaded:extract_4.extract","timestamp_1.done:format_timestamp_v2_1.format","patch_json_v2_2.data:patch_json_v2_6.data","patch_json_v2_6.data:map_any_to_table_rows_1.data","fb_select_ad_account_id_v2_1.ad_account_id:fb_select_ad_account_id_v2_2.ad_account_id","trigger_relay_2.relayed:delete_file_1.delete","extract_2.extracted:replace_string_1.replace","patch_json_v2_7.data:google_drive_fetch_files_v2_2.filters","patch_json_v2_8.data:google_drive_fetch_files_v2_1.filters","input_boolean_1.boolean:google_drive_fetch_files_v2_1.include_sub_folders","google_drive_fetch_files_v2_1.files:concat_1.b","google_drive_select_folder_id_1.folder_id:google_drive_fetch_files_v2_2.parent_folder_id","patch_json_v2_8.patched:timestamp_3.now","concat_1.list:for_each_v2_1.items","google_drive_fetch_files_v2_2.files:concat_1.a","google_drive_select_folder_id_1.folder_id:google_drive_fetch_files_v2_1.parent_folder_id","patch_json_v2_8.patched:google_drive_fetch_files_v2_2.fetch","concat_1.done:for_each_v2_1.start","input_boolean_1.boolean:google_drive_fetch_files_v2_2.include_sub_folders","for_each_v2_1.done:delay_1.start","delay_1.delayed:google_sheets_fetch_table_rows_v3_1.fetch","fetch_variable_1.data:patch_json_v2_8.value","timestamp_3.timestamp:update_variable_1.data","timestamp_3.done:update_variable_1.update","fetch_variable_1.fetched:patch_json_v2_7.patch","patch_json_v2_7.patched:patch_json_v2_8.patch","patch_json_v2_8.patched:google_drive_fetch_files_v2_1.fetch","google_drive_fetch_files_v2_1.fetched:join_1.triggers","update_variable_1.updated:join_1.triggers","fetch_variable_1.data:patch_json_v2_7.value","google_drive_fetch_files_v2_2.fetched:join_1.triggers","join_1.joined:concat_1.concat","extract_list_1.extracted:fetch_variable_1.fetch"],"groups":{"group_2":{"title":"Upload File","description":"","x":1411,"y":244,"inputs":["extract_1.extract","google_sheets_select_spreadsheet_id_v2_2.range","google_sheets_select_spreadsheet_id_v2_2.spreadsheet_id","data_relay_1.data","data_relay_4.data"],"outputs":["delete_file_1.deleted"]},"group_4":{"title":"Skip?","description":"","x":1102,"y":508,"inputs":["input_string_1.string","if_v2_1.evaluate","extract_2.data","if_v2_2.b"],"outputs":["if_v2_2.false","trigger_relay_1.relayed","replace_string_1.data"]},"group_11":{"title":"Get New Files","description":"","x":466,"y":305,"inputs":["fetch_variable_1.fetch"],"outputs":["concat_1.list","concat_1.done"]},"group_1":{"title":"Get existing assets","description":"","x":217,"y":446,"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_3":{"title":"Download File","description":"","x":401,"y":434,"group":"group_2","inputs":["extract_1.data","extract_1.extract"],"outputs":["google_drive_download_file_1.url","google_drive_download_file_1.downloaded"]},"group_7":{"title":"Upload and add to Sheet","description":"","x":882,"y":206,"group":"group_2","inputs":["data_relay_2.data","google_sheets_select_spreadsheet_id_v2_2.spreadsheet_id","google_sheets_select_spreadsheet_id_v2_2.range","fb_select_ad_account_id_v2_2.ad_account_id","data_relay_3.data","data_relay_4.data","extract_4.extract"],"outputs":["trigger_relay_2.relayed"]},"group_8":{"title":"Clone to S3","description":"","x":996,"y":672,"group":"group_7","inputs":["extract_3.extract","extract_3.data"],"outputs":["clone_file_v2_1.cloned","clone_file_v2_1.url"]},"group_6":{"title":"Map Rows","description":"","x":1287,"y":671,"group":"group_7","inputs":["patch_json_v2_2.value","patch_json_v2_3.value","patch_json_v2_3.data","patch_json_v2_3.patch"],"outputs":["map_any_to_table_rows_1.mapped","map_any_to_table_rows_1.rows"]},"group_9":{"title":"Determine Action","description":"","x":307,"y":424,"group":"group_7","inputs":["data_relay_3.data","extract_4.extract"],"outputs":["if_v2_3.false","if_v2_3.true"]},"group_10":{"title":"Clone to S3","description":"","x":976,"y":318,"group":"group_7","inputs":["extract_5.data","extract_5.extract"],"outputs":["clone_file_v2_2.url","clone_file_v2_2.cloned"]},"group_5":{"title":"Map Rows","description":"","x":1283,"y":328,"group":"group_7","inputs":["patch_json_v2_4.value","patch_json_v2_5.data","patch_json_v2_5.value","patch_json_v2_5.patch"],"outputs":["map_any_to_table_rows_2.rows","map_any_to_table_rows_2.mapped"]}},"widgets":{"widget_1":{"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_2":{"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_3":{"title":"Skip uploaded assets","description":"If set to \"Skip\", any files already in the tab will be skipped. Note: Check takes place on asset name basis without file extension. E.g. if an asset called `test.png` has been uploaded before and added to the spreadsheet, another asset called `test.mp4` would not be uploaded.","position":9,"icon":"las la-filter","options":[{"data":"skip","title":"Skip"},{"data":"dontskip","title":"Upload all (don't skip)"}],"input":"input_string_1.string"},"widget_4":{"title":"Ad Accounts","description":"Select a Facebook Account","position":0,"input":"fb_select_ad_account_id_v2_1.ad_account_id"},"widget_5":{"title":"Folder","description":"Select a folder.","position":1,"icon":"","input":"google_drive_select_folder_id_1.folder_id"},"widget_6":{"title":"Include subfolders?","description":"Searches also in subfolder of parent folder. Make sure that the parent folder is explicitly shared with the connected GDrive account. Otherwise sub-folders cannot be searched.","position":2,"icon":"las la-folder-open","options":[{"data":true,"title":"TRUE"},{"data":false,"title":"FALSE"}],"input":"input_boolean_1.boolean"}},"variables":{"variable_1":{"name":"timestamp","data":1675206000}},"config":{"capture_inputs_enabled":false,"caching_enabled":false},"tags":[]}
How To
1. This automation this automation will upload files that are created or modified AFTER February 1st, 2023 in the first run and then any new files added thereafter.
If you want to change the initial timestamp, here’s how to do it:
- Open the automation in Builder view and click on “Menu” in the top left corner
- Click on “Variables”
- Click “Edit” to edit the timestamp value.
- Go to https://www.unixtimestamp.com/ and enter a date & time of the date from where you want to upload files.
- Copy the value and paste it into the “Value” field and hit save.
2. Let’s move over to the Widgets: Select a Facebook ad account, a folder and whether you’d like to include subfolders.
3. Select an output spreadsheet and tab. If you are using the Bulk Ad Creation recipe, make sure to specify the “Assets” tab.
Advanced
If you want to understand how exactly the automation works under the hood, take a look at this 4 minute video explanation.
Related FAQs:
Last updated on February 8, 2023