Snapchat Bulk Ad Uploading

Export Media from Snapchat to sheet

{"name":"Export Snapchat Media ","description":"A blank recipe","nodes":{"append_1":{"type":"append","logging_enabled":false,"error_rules":[],"x":2076,"y":328,"inputs":{"flatten":{"export_enabled":true,"data":true},"schema":{"export_enabled":true,"data":"any"}}},"map_any_to_table_rows_1":{"type":"map_any_to_table_rows","logging_enabled":false,"error_rules":[],"x":1277,"y":333,"group":"group_1","inputs":{"add_header":{"export_enabled":true,"data":true},"mapping":{"export_enabled":true,"data":{"A":"/name","B":"/type","C":"/id","D":"/created_at","E":"/download_link","F":"/thumbnail"}},"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":2015,"y":376,"group":"group_1"},"google_sheets_select_spreadsheet_id_v2_1":{"type":"google_sheets_select_spreadsheet_id_v2","logging_enabled":false,"error_rules":[],"x":1263,"y":63,"group":"group_1","inputs":{"range":{"export_enabled":true,"data":"Assets"},"spreadsheet_id":{"export_enabled":true,"data":{"id":"1eJINwEyM5IR4CA8S11JnlImPWSNJC9J49RQniWqVPvE","context":{"mime_type":"application/vnd.google-apps.spreadsheet","ui":{"id":"1eJINwEyM5IR4CA8S11JnlImPWSNJC9J49RQniWqVPvE","name":"TGM | Snapchat - Bulk ad Upload","owners":[{"displayName":"Jana Ismail","kind":"drive#user","me":false,"permissionId":"15497214979118595172","emailAddress":"janai@nestcommerce.co","photoLink":"https://lh3.googleusercontent.com/a/default-user=s64"}],"mime_type":"application/vnd.google-apps.spreadsheet"}},"provider":"google_drive","type":"file"}}}},"google_sheets_clear_table_rows_v3_1":{"type":"google_sheets_clear_table_rows_v3","logging_enabled":false,"error_rules":[],"x":1682,"y":286,"group":"group_1","inputs":{"clear":{"title":"clear","description":"Starts the clear"}}},"delay_1":{"type":"delay","logging_enabled":false,"error_rules":[],"x":66,"y":616,"inputs":{"duration":{"export_enabled":true,"data":1800}}},"stop_1":{"type":"stop","logging_enabled":false,"error_rules":[],"x":1745,"y":1028,"inputs":{"stop":{"export_enabled":true}}},"filter_v2_1":{"type":"filter_v2","logging_enabled":false,"error_rules":[],"x":1242,"y":325,"inputs":{"filters":{"export_enabled":true,"data":[{"operator":"=","pointer":"/media_status","value":"READY"},{"operator":"\u003e","pointer":"/created_at","value":"2023-12-01"}]}}},"unique_1":{"type":"unique","logging_enabled":false,"error_rules":[],"x":966,"y":314,"inputs":{"pointer":{"export_enabled":true,"data":"/file_name"},"keep_first":{"export_enabled":true,"data":false}}},"snapchat_select_ad_account_id_1":{"type":"snapchat_select_ad_account_id","logging_enabled":false,"error_rules":[],"x":54,"y":351,"inputs":{"ad_account_id":{"export_enabled":true}}},"concat_1":{"type":"concat","logging_enabled":false,"error_rules":[],"x":385,"y":289,"inputs":{"b":{"export_enabled":true},"schema":{"export_enabled":true,"data":"any"}}},"snapchat_fetch_media_list_1":{"type":"snapchat_fetch_media_list","title":"Fetch Snapchat Media List","description":"Fetches list of media details from a list of media ids","logging_enabled":false,"max_job_retries":6,"timeout":600,"error_rules":[],"x":692,"y":323},"start_1":{"type":"start","logging_enabled":false,"error_rules":[],"x":146,"y":146},"fetch_integration_url_v2_1":{"type":"fetch_integration_url_v2","logging_enabled":false,"error_rules":[],"x":2096,"y":772,"group":"group_2","inputs":{"headers":{"export_enabled":true},"field":{"export_enabled":true},"all_pages":{"export_enabled":true},"provider":{"export_enabled":true,"data":"snapchat"}}},"for_each_v2_1":{"type":"for_each_v2","logging_enabled":false,"error_rules":[],"x":1506,"y":353},"patch_json_v3_1":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1817,"y":811,"group":"group_2","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"","value":"https://adsapi.snapchat.com/v1/media/{{inputValue(\"/id\")}}/preview"}]},"data":{"export_enabled":true}}},"patch_json_v3_2":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":2941,"y":882,"group":"group_2","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/thumbnail","value":"{{inputValue(\"\")}}"}]}}},"extract_v2_1":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":2371,"y":843,"group":"group_2","inputs":{"default_value":{"export_enabled":true},"pointer":{"export_enabled":true,"data":"/link"}}},"clone_file_v2_1":{"type":"clone_file_v2","logging_enabled":false,"error_rules":[],"x":2629,"y":889,"group":"group_2"},"data_relay_1":{"type":"data_relay","logging_enabled":false,"error_rules":[],"x":1493,"y":1083,"group":"group_2"}},"edges":[{"id":"google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id:google_sheets_clear_table_rows_v3_1.spreadsheet_id","points":[]},{"id":"google_sheets_clear_table_rows_v3_1.cleared:google_sheets_append_table_rows_v3_1.append","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_1.range:google_sheets_clear_table_rows_v3_1.range","points":[]},{"id":"map_any_to_table_rows_1.rows:google_sheets_append_table_rows_v3_1.rows","points":[]},{"id":"map_any_to_table_rows_1.mapped:google_sheets_clear_table_rows_v3_1.clear","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.spreadsheet_id:google_sheets_append_table_rows_v3_1.spreadsheet_id","points":[]},{"id":"snapchat_select_ad_account_id_1.ad_account_id:concat_1.a","points":[]},{"id":"concat_1.list:snapchat_fetch_media_list_1.ad_account_ids","points":[]},{"id":"concat_1.done:snapchat_fetch_media_list_1.fetch","points":[]},{"id":"delay_1.delayed:concat_1.concat","points":[]},{"id":"start_1.start:concat_1.concat","points":[]},{"id":"google_sheets_append_table_rows_v3_1.appended:delay_1.start","points":[]},{"id":"snapchat_fetch_media_list_1.media_list:unique_1.data_list","points":[]},{"id":"snapchat_fetch_media_list_1.fetched:unique_1.filter","points":[]},{"id":"unique_1.data_list:filter_v2_1.items","points":[]},{"id":"unique_1.filtered:filter_v2_1.filter","points":[]},{"id":"filter_v2_1.items:for_each_v2_1.items","points":[]},{"id":"patch_json_v3_1.data:fetch_integration_url_v2_1.url","points":[]},{"id":"fetch_integration_url_v2_1.fetched:extract_v2_1.extract","points":[]},{"id":"fetch_integration_url_v2_1.body:extract_v2_1.data","points":[]},{"id":"extract_v2_1.data:clone_file_v2_1.url","points":[]},{"id":"extract_v2_1.extracted:clone_file_v2_1.clone","points":[]},{"id":"clone_file_v2_1.url:patch_json_v3_2.value","points":[]},{"id":"clone_file_v2_1.cloned:patch_json_v3_2.patch","points":[]},{"id":"patch_json_v3_2.data:append_1.item","points":[]},{"id":"patch_json_v3_2.patched:append_1.append","points":[]},{"id":"append_1.resetted:for_each_v2_1.start","points":[]},{"id":"patch_json_v3_1.patched:fetch_integration_url_v2_1.fetch","points":[]},{"id":"for_each_v2_1.do:patch_json_v3_1.patch","points":[]},{"id":"append_1.appended:for_each_v2_1.next","points":[]},{"id":"filter_v2_1.filtered:append_1.reset","points":[]},{"id":"data_relay_1.data:patch_json_v3_2.data","points":[]},{"id":"for_each_v2_1.item:data_relay_1.data","points":[]},{"id":"for_each_v2_1.done:map_any_to_table_rows_1.map","points":[]},{"id":"append_1.list:map_any_to_table_rows_1.data","points":[]},{"id":"data_relay_1.data:patch_json_v3_1.value","points":[]}],"groups":{"group_1":{"title":"Update Sheet","description":"","x":2405,"y":425,"inputs":["map_any_to_table_rows_1.data","map_any_to_table_rows_1.map"],"outputs":["google_sheets_append_table_rows_v3_1.appended"]},"group_2":{"title":"Fetch Media's Thumbnail","description":"","x":1777,"y":396,"inputs":["patch_json_v3_1.patch","data_relay_1.data"],"outputs":["patch_json_v3_2.data","patch_json_v3_2.patched"]}},"widgets":{"widget_1":{"title":"Filters","description":"Add filters that will be applied to the items","position":10,"icon":"las la-filter","input":"filter_v2_1.filters"},"widget_2":{"title":"Tab","description":"Select or enter the range in the selected spreadsheet in 'A1 notation'","position":2,"input":"google_sheets_select_spreadsheet_id_v2_1.range"},"widget_3":{"title":"Spreadsheet","description":"Select or enter id of the spreadsheet","position":0,"input":"google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id"},"widget_4":{"title":"Ad Account","description":"Selected ad account id","position":-1,"input":"snapchat_select_ad_account_id_1.ad_account_id"},"widget_5":{"title":"Run every","description":"Set the delay duration","position":10,"icon":"las la-hourglass","input":"delay_1.duration"}},"variables":{},"config":{"capture_inputs_enabled":false,"caching_enabled":false},"tags":[{"name":"Alway on","color":"#6B93E1"}]}

Upload Assets from GDrive

{"name":"Upload Assets (Gdrive)","description":"Basic scaffold for automation.","nodes":{"stop_1":{"type":"stop","logging_enabled":false,"error_rules":[],"x":135,"y":952,"inputs":{"stop":{"export_enabled":true}}},"start_1":{"type":"start","logging_enabled":false,"error_rules":[],"x":50,"y":472},"for_each_v2_1":{"type":"for_each_v2","logging_enabled":false,"error_rules":[],"x":1012,"y":327,"inputs":{"items":{"title":"files","description":"The items to iterate over"},"start":{"title":" start","description":"Starts the first iteration"}},"outputs":{"item":{"title":"file","description":"The current item of the iteration"}}},"data_relay_1":{"type":"data_relay","logging_enabled":false,"error_rules":[],"x":191,"y":475,"group":"group_1","inputs":{"data":{"title":"file","description":"Data to relay"}}},"delay_1":{"type":"delay","logging_enabled":false,"error_rules":[],"x":11,"y":730,"inputs":{"duration":{"export_enabled":true,"data":1800}}},"extract_1":{"type":"extract","logging_enabled":false,"error_rules":[],"x":442,"y":274,"group":"group_1","inputs":{"pointer":{"export_enabled":true,"data":"/mimeType"}},"outputs":{"data":{"title":"type","description":"The extracted data"}}},"map_table_rows_to_any_1":{"type":"map_table_rows_to_any","logging_enabled":false,"error_rules":[],"x":718,"y":338,"group":"group_2","inputs":{"mapping":{"export_enabled":true,"data":{"A":"/name","C":"/id"}},"schema":{"export_enabled":true,"data":"any_list"}}},"extract_2":{"type":"extract","logging_enabled":false,"error_rules":[],"x":1267,"y":392,"inputs":{"pointer":{"export_enabled":true,"data":"/name"},"extract":{"title":"extract","description":"Starts the extraction"}}},"if_v2_1":{"type":"if_v2","logging_enabled":false,"error_rules":[],"x":1866,"y":431,"inputs":{"condition":{"export_enabled":true,"data":"in"}}},"delete_file_1":{"type":"delete_file","logging_enabled":false,"error_rules":[],"x":3090,"y":533},"google_sheets_fetch_table_rows_v3_1":{"type":"google_sheets_fetch_table_rows_v3","logging_enabled":false,"error_rules":[],"x":415,"y":324,"group":"group_2","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"},"range":{"export_enabled":true,"data":"Assets"},"spreadsheet_id":{"export_enabled":true,"data":{"id":"1eJINwEyM5IR4CA8S11JnlImPWSNJC9J49RQniWqVPvE","context":{"mime_type":"application/vnd.google-apps.spreadsheet","ui":{"id":"1eJINwEyM5IR4CA8S11JnlImPWSNJC9J49RQniWqVPvE","name":"TGM | Snapchat - Bulk ad Upload","owners":[{"displayName":"Jana Ismail","kind":"drive#user","me":false,"permissionId":"15497214979118595172","emailAddress":"janai@nestcommerce.co","photoLink":"https://lh3.googleusercontent.com/a/ACg8ocIMh7g9ghW6yYOuU5NWD4XxVIqLlNqL_dBWLIvXH1dl=s64"}],"mime_type":"application/vnd.google-apps.spreadsheet"}},"provider":"google_drive","type":"file"}}}},"snapchat_create_media_v2_1":{"type":"snapchat_create_media_v2","title":"Snapchat Create Media","description":"Create a media in snapchat inside an account and returns an id","logging_enabled":true,"max_job_retries":6,"timeout":30,"error_rules":[{"error_type":"integration/client/response_error","expression":"media does not meet our requirements"}],"x":2760,"y":420,"inputs":{"create":{"title":"create","description":"Starts the creation"}}},"extract_list_1":{"type":"extract_list","logging_enabled":false,"error_rules":[],"x":1018,"y":414,"group":"group_2","inputs":{"pointer":{"export_enabled":true,"data":"/name"}},"outputs":{"data_list":{"title":"uploaded_creatives","description":"The list of extracted data"}}},"google_drive_fetch_files_v2_1":{"type":"google_drive_fetch_files_v2","logging_enabled":false,"error_rules":[],"x":238,"y":342,"inputs":{"parent_folder_id":{"export_enabled":true},"filters":{"export_enabled":true,"data":[]},"include_sub_folders":{"export_enabled":true,"data":true},"mime_types":{"export_enabled":true,"data":["image/jpeg","image/png","video/mp4","video/quicktime"]}}},"snapchat_select_ad_account_id_1":{"type":"snapchat_select_ad_account_id","logging_enabled":false,"error_rules":[],"x":125,"y":110,"inputs":{"ad_account_id":{"export_enabled":true}}},"extract_3":{"type":"extract","title":"Extract: Name","description":"Allows to extract data with a pointer","logging_enabled":false,"error_rules":[],"x":2073,"y":691,"group":"group_1","inputs":{"pointer":{"export_enabled":true,"data":"/name"}},"outputs":{"extracted":{"title":"extracted","description":"Triggers when the data was extracted"},"data":{"title":"name","description":"The extracted data"}}},"replace_string_1":{"type":"replace_string","logging_enabled":false,"error_rules":[],"x":1306,"y":206,"group":"group_1","inputs":{"value":{"export_enabled":true,"data":""},"regex":{"export_enabled":true,"data":".*/"},"pointer":{"export_enabled":true,"data":""},"schema":{"export_enabled":true,"data":"string"}},"outputs":{"data":{"title":"type","description":"Data that has been partially replaced"}}},"google_drive_download_file_1":{"type":"google_drive_download_file","logging_enabled":false,"error_rules":[],"x":1795,"y":590,"group":"group_1"},"patch_json_v3_1":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1533,"y":508,"group":"group_1","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/id","value":"{{inputValue(\"/id\")}}"},{"op":"replace","path":"/context/mime_type","value":"{{inputValue(\"/mimeType\")}}"}]},"data":{"export_enabled":true,"data":{"id":"","type":"file","provider":"google_drive","context":{"mime_type":"video/mp4"}}}}},"replace_string_2":{"type":"replace_string","logging_enabled":false,"error_rules":[],"x":1041,"y":202,"group":"group_1","inputs":{"value":{"export_enabled":true,"data":"mov"},"regex":{"export_enabled":true,"data":"quicktime"},"pointer":{"export_enabled":true,"data":""},"schema":{"export_enabled":true,"data":"string"}},"outputs":{"data":{"title":"type","description":"Data that has been partially replaced"}}},"map_any_to_table_rows_1":{"type":"map_any_to_table_rows","logging_enabled":false,"error_rules":[],"x":1419,"y":865,"group":"group_3","inputs":{"add_header":{"export_enabled":true,"data":true},"mapping":{"export_enabled":true,"data":{"A":"/name","B":"/type","C":"/id","D":"/created_at","E":"/download_link"}},"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":2157,"y":908,"group":"group_3"},"google_sheets_select_spreadsheet_id_v2_1":{"type":"google_sheets_select_spreadsheet_id_v2","logging_enabled":false,"error_rules":[],"x":1405,"y":595,"group":"group_3","inputs":{"spreadsheet_id":{"export_enabled":true},"range":{"export_enabled":true,"data":"Assets"}}},"google_sheets_clear_table_rows_v3_1":{"type":"google_sheets_clear_table_rows_v3","logging_enabled":false,"error_rules":[],"x":1824,"y":818,"group":"group_3"},"snapchat_fetch_media_list_1":{"type":"snapchat_fetch_media_list","title":"Fetch Snapchat Media List","description":"Fetches list of media details from a list of media ids","logging_enabled":false,"max_job_retries":6,"timeout":600,"error_rules":[],"x":1519,"y":832,"group":"group_4"},"unique_1":{"type":"unique","logging_enabled":false,"error_rules":[],"x":2325,"y":841,"group":"group_4","inputs":{"pointer":{"export_enabled":true,"data":"/file_name"},"keep_first":{"export_enabled":true,"data":false}}},"filter_v2_1":{"type":"filter_v2","logging_enabled":false,"error_rules":[],"x":1808,"y":826,"group":"group_4","inputs":{"filters":{"export_enabled":true,"data":[{"operator":"=","pointer":"/media_status","value":"READY"},{"operator":">","pointer":"/created_at","value":"2024-01-01"}]}}},"replace_string_3":{"type":"replace_string","logging_enabled":false,"error_rules":[],"x":733,"y":197,"group":"group_1","inputs":{"value":{"export_enabled":true,"data":"jpg"},"regex":{"export_enabled":true,"data":"jpeg"},"pointer":{"export_enabled":true,"data":""},"schema":{"export_enabled":true,"data":"string"}},"outputs":{"data":{"title":"type","description":"Data that has been partially replaced"}}},"filter_v2_2":{"type":"filter_v2","logging_enabled":false,"error_rules":[],"x":500,"y":420,"inputs":{"filters":{"export_enabled":true,"data":[{"operator":"not_contains","pointer":"/name","value":"_4X5_"},{"operator":"not_contains","pointer":"/name","value":"_1.91.1_"}]}}},"sort_1":{"type":"sort","logging_enabled":false,"error_rules":[],"x":2079,"y":841,"group":"group_4","inputs":{"direction":{"export_enabled":true,"data":"DESC"},"pointer":{"export_enabled":true,"data":"/created_at"}}},"replace_string_4":{"type":"replace_string","logging_enabled":false,"error_rules":[],"x":2368,"y":710,"group":"group_1","inputs":{"value":{"export_enabled":true,"data":""},"regex":{"export_enabled":true,"data":"\\..*"},"pointer":{"export_enabled":true,"data":""},"schema":{"export_enabled":true,"data":"any"}},"outputs":{"data":{"title":"name","description":"The data with the replaced string"}}},"input_boolean_1":{"type":"input_boolean","logging_enabled":false,"error_rules":[],"x":1638,"y":171,"inputs":{"boolean":{"export_enabled":true,"data":true}}},"if_v2_2":{"type":"if_v2","logging_enabled":false,"error_rules":[],"x":2120,"y":434,"inputs":{"b":{"export_enabled":true,"data":false},"condition":{"export_enabled":true,"data":"equal"}}},"patch_json_v3_2":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":2392,"y":445,"inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"","value":"{{formatTime(timeNow(\"UTC\"), \"%d-%m-%Y\")}}{{inputValue(\"\")}}"}]},"data":{"export_enabled":true}}},"concat_1":{"type":"concat","logging_enabled":false,"error_rules":[],"x":1213,"y":798,"group":"group_4","inputs":{"b":{"export_enabled":true},"schema":{"export_enabled":true,"data":"any"}}}},"edges":[{"id":"replace_string_3.replaced:replace_string_2.replace","points":[]},{"id":"replace_string_2.data:replace_string_1.data","points":[]},{"id":"replace_string_1.data:snapchat_create_media_v2_1.type","points":[{"x":2079,"y":598},{"x":2079,"y":601},{"x":2053,"y":601}]},{"id":"replace_string_2.replaced:replace_string_1.replace","points":[]},{"id":"replace_string_3.data:replace_string_2.data","points":[]},{"id":"data_relay_1.data:extract_1.data","points":[]},{"id":"data_relay_1.data:extract_3.data","points":[]},{"id":"for_each_v2_1.item:data_relay_1.data","points":[]},{"id":"extract_list_1.data_list:if_v2_1.b","points":[]},{"id":"delay_1.delayed:google_drive_fetch_files_v2_1.fetch","points":[]},{"id":"google_sheets_fetch_table_rows_v3_1.rows:map_table_rows_to_any_1.rows","points":[]},{"id":"google_sheets_fetch_table_rows_v3_1.fetched:map_table_rows_to_any_1.map","points":[]},{"id":"for_each_v2_1.item:extract_2.data","points":[]},{"id":"extract_2.data:if_v2_1.a","points":[]},{"id":"for_each_v2_1.do:extract_2.extract","points":[]},{"id":"google_drive_download_file_1.downloaded:extract_3.extract","points":[]},{"id":"google_drive_download_file_1.url:snapchat_create_media_v2_1.url","points":[]},{"id":"replace_string_1.replaced:patch_json_v3_1.patch","points":[]},{"id":"patch_json_v3_1.patched:google_drive_download_file_1.download","points":[]},{"id":"data_relay_1.data:patch_json_v3_1.value","points":[]},{"id":"patch_json_v3_1.data:google_drive_download_file_1.file_id","points":[]},{"id":"google_drive_download_file_1.url:delete_file_1.url","points":[]},{"id":"snapchat_create_media_v2_1.created:delete_file_1.delete","points":[]},{"id":"extract_list_1.extracted:for_each_v2_1.start","points":[]},{"id":"map_table_rows_to_any_1.data:extract_list_1.data_list","points":[]},{"id":"map_table_rows_to_any_1.mapped:extract_list_1.extract","points":[]},{"id":"snapchat_select_ad_account_id_1.ad_account_id:snapchat_create_media_v2_1.ad_account_id","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id:google_sheets_clear_table_rows_v3_1.spreadsheet_id","points":[]},{"id":"google_sheets_clear_table_rows_v3_1.cleared:google_sheets_append_table_rows_v3_1.append","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_1.range:google_sheets_clear_table_rows_v3_1.range","points":[]},{"id":"map_any_to_table_rows_1.rows:google_sheets_append_table_rows_v3_1.rows","points":[]},{"id":"map_any_to_table_rows_1.mapped:google_sheets_clear_table_rows_v3_1.clear","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.spreadsheet_id:google_sheets_append_table_rows_v3_1.spreadsheet_id","points":[]},{"id":"concat_1.list:snapchat_fetch_media_list_1.ad_account_ids","points":[]},{"id":"concat_1.done:snapchat_fetch_media_list_1.fetch","points":[]},{"id":"for_each_v2_1.done:concat_1.concat","points":[]},{"id":"snapchat_select_ad_account_id_1.ad_account_id:concat_1.a","points":[]},{"id":"start_1.start:google_drive_fetch_files_v2_1.fetch","points":[]},{"id":"delete_file_1.deleted:for_each_v2_1.next","points":[]},{"id":"extract_1.data:replace_string_3.data","points":[]},{"id":"extract_1.extracted:replace_string_3.replace","points":[]},{"id":"snapchat_create_media_v2_1.failed:delete_file_1.delete","points":[]},{"id":"google_drive_fetch_files_v2_1.files:filter_v2_2.items","points":[]},{"id":"google_drive_fetch_files_v2_1.fetched:filter_v2_2.filter","points":[]},{"id":"filter_v2_2.filtered:google_sheets_fetch_table_rows_v3_1.fetch","points":[]},{"id":"filter_v2_2.items:for_each_v2_1.items","points":[]},{"id":"snapchat_fetch_media_list_1.media_list:filter_v2_1.items","points":[]},{"id":"snapchat_fetch_media_list_1.fetched:filter_v2_1.filter","points":[]},{"id":"filter_v2_1.items:sort_1.items","points":[]},{"id":"filter_v2_1.filtered:sort_1.sort","points":[]},{"id":"sort_1.items:unique_1.data_list","points":[]},{"id":"sort_1.sorted:unique_1.filter","points":[]},{"id":"unique_1.filtered:map_any_to_table_rows_1.map","points":[]},{"id":"extract_2.extracted:extract_1.extract","points":[]},{"id":"unique_1.data_list:map_any_to_table_rows_1.data","points":[]},{"id":"extract_3.data:replace_string_4.data","points":[]},{"id":"extract_3.extracted:replace_string_4.replace","points":[]},{"id":"replace_string_4.replaced:if_v2_1.evaluate","points":[]},{"id":"input_boolean_1.boolean:if_v2_2.a","points":[]},{"id":"if_v2_1.true:if_v2_2.evaluate","points":[]},{"id":"if_v2_2.true:patch_json_v3_2.patch","points":[]},{"id":"if_v2_1.false:snapchat_create_media_v2_1.create","points":[]},{"id":"replace_string_4.data:patch_json_v3_2.value","points":[]},{"id":"patch_json_v3_2.data:snapchat_create_media_v2_1.name","points":[]},{"id":"patch_json_v3_2.patched:snapchat_create_media_v2_1.create","points":[]},{"id":"if_v2_2.false:for_each_v2_1.next","points":[]},{"id":"google_sheets_append_table_rows_v3_1.appended:delay_1.start","points":[]}],"groups":{"group_2":{"title":"Get already uploaded","description":"","x":751,"y":409,"inputs":["google_sheets_fetch_table_rows_v3_1.fetch"],"outputs":["extract_list_1.data_list","extract_list_1.extracted"]},"group_1":{"title":"Prepare File","description":"","x":1546,"y":423,"inputs":["data_relay_1.data","extract_1.extract"],"outputs":["replace_string_1.data","google_drive_download_file_1.url","replace_string_4.data","replace_string_4.replaced"]},"group_3":{"title":"Update Sheet","description":"","x":1670,"y":851,"inputs":["map_any_to_table_rows_1.data","map_any_to_table_rows_1.map"],"outputs":["google_sheets_append_table_rows_v3_1.appended"]},"group_4":{"title":"Prepare Data","description":"","x":1400,"y":846,"inputs":["concat_1.a","concat_1.concat"],"outputs":["unique_1.data_list","unique_1.filtered"]}},"widgets":{"widget_1":{"title":"Tab","description":"Select or enter the range in the selected spreadsheet in 'A1 notation'","position":2,"input":"google_sheets_select_spreadsheet_id_v2_1.range"},"widget_2":{"title":"Ad Account","description":"Selected ad account id","position":-2,"input":"snapchat_select_ad_account_id_1.ad_account_id"},"widget_3":{"title":"Include Sub-folders?","description":"Set this option to also fetch files from subfolders of the parent folder. Make sure that the parent folder is explicitly shared with the connected Google Drive account. Otherwise subfolders cannot be searched.","position":1,"options":[{"data":true,"title":"TRUE"},{"data":false,"title":"FALSE"}],"input":"google_drive_fetch_files_v2_1.include_sub_folders"},"widget_4":{"title":"Folder","description":"Select or enter the id of the folder from which you want to fetch the files. ","position":0,"input":"google_drive_fetch_files_v2_1.parent_folder_id"},"widget_5":{"title":"Skip Assets with Duplicate Names?","description":"True: skip\nFalse: Add today's date to name","position":-1,"options":[{"data":true,"title":"TRUE"},{"data":false,"title":"FALSE"}],"input":"input_boolean_1.boolean"},"widget_6":{"title":"Spreadsheet","description":"Select or enter id of the spreadsheet","position":0,"input":"google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id"},"widget_7":{"title":"Filters","description":"Add filters that will be applied to the items","position":10,"icon":"las la-filter","input":"filter_v2_1.filters"}},"variables":{},"config":{"capture_inputs_enabled":false,"caching_enabled":false},"tags":[{"name":"Alway on","color":"#6B93E1"}]}

Export ad groups to sheet

{"name":"Export Adsets \u0026 Campaigns","description":"A blank recipe","nodes":{"start_1":{"type":"start","logging_enabled":false,"error_rules":[],"x":150,"y":50},"google_sheets_clear_table_rows_v3_1":{"type":"google_sheets_clear_table_rows_v3","logging_enabled":false,"error_rules":[],"x":1323,"y":420,"group":"group_1"},"google_sheets_append_table_rows_v3_1":{"type":"google_sheets_append_table_rows_v3","logging_enabled":false,"error_rules":[],"x":1573,"y":421,"group":"group_1"},"snapchat_select_ad_account_id_1":{"type":"snapchat_select_ad_account_id","logging_enabled":false,"error_rules":[],"x":54,"y":459,"inputs":{"ad_account_id":{"export_enabled":true}}},"stop_1":{"type":"stop","logging_enabled":false,"error_rules":[],"x":1721,"y":612},"google_sheets_select_spreadsheet_id_v2_1":{"type":"google_sheets_select_spreadsheet_id_v2","logging_enabled":false,"error_rules":[],"x":465,"y":61,"group":"group_1","inputs":{"range":{"export_enabled":true,"data":"Adsets"},"spreadsheet_id":{"export_enabled":true,"data":{"id":"1eJINwEyM5IR4CA8S11JnlImPWSNJC9J49RQniWqVPvE","context":{"mime_type":"application/vnd.google-apps.spreadsheet","ui":{"id":"1eJINwEyM5IR4CA8S11JnlImPWSNJC9J49RQniWqVPvE","name":"TGM | Snapchat - Bulk ad Upload","owners":[{"displayName":"Jana Ismail","kind":"drive#user","me":false,"permissionId":"15497214979118595172","emailAddress":"janai@nestcommerce.co","photoLink":"https://lh3.googleusercontent.com/a/default-user=s64"}],"mime_type":"application/vnd.google-apps.spreadsheet"}},"provider":"google_drive","type":"file"}}}},"map_any_to_table_rows_1":{"type":"map_any_to_table_rows","logging_enabled":false,"error_rules":[],"x":1078,"y":424,"group":"group_1","inputs":{"add_header":{"export_enabled":true,"data":false},"mapping":{"export_enabled":true,"data":{"A":"/adsquad_id","B":"/adsquad_name","C":"/campaign_id","D":"/target/campaign_name"}},"schema":{"export_enabled":true,"data":"any_list"}}},"join_data_1":{"type":"join_data","logging_enabled":false,"error_rules":[],"x":1119,"y":451,"inputs":{"conditions":{"export_enabled":true,"data":[{"a":"/campaign_id","b":"/id"}]},"target":{"export_enabled":true,"data":"/target"},"join":{"title":"join","description":"Triggers the joining"}}},"patch_json_list_v3_1":{"type":"patch_json_list_v3","logging_enabled":false,"error_rules":[],"x":1358,"y":575,"group":"group_2","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/adsquad_name","value":"{{inputData(\"/name\")}}"},{"op":"add","path":"/adsquad_id","value":"{{inputData(\"/id\")}}"},{"op":"add","path":"/created_at_adsquad","value":"{{inputData(\"/created_ad\")}}"}]},"value":{"export_enabled":true}}},"sort_1":{"type":"sort","logging_enabled":false,"error_rules":[],"x":835,"y":418,"group":"group_1","inputs":{"direction":{"export_enabled":true,"data":"ASC"},"pointer":{"export_enabled":true,"data":"/created_at_adsquad"}}},"patch_json_list_v3_2":{"type":"patch_json_list_v3","logging_enabled":false,"error_rules":[],"x":1685,"y":376,"group":"group_3","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/campaign_name","value":"{{inputData(\"/name\")}}"},{"op":"add","path":"/campaign_id","value":"{{inputData(\"/id\")}}"}]},"value":{"export_enabled":true}}},"fetch_integration_url_v2_1":{"type":"fetch_integration_url_v2","logging_enabled":false,"error_rules":[],"x":914,"y":370,"group":"group_3","inputs":{"headers":{"export_enabled":true},"field":{"export_enabled":true},"all_pages":{"export_enabled":true},"provider":{"export_enabled":true,"data":"snapchat"}}},"patch_json_v3_1":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":669,"y":369,"group":"group_3","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"","value":"https://adsapi.snapchat.com/v1/adaccounts/{{inputValue(\"/id\")}}/campaigns"}]},"data":{"export_enabled":true}}},"extract_v2_1":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":1165,"y":372,"group":"group_3","inputs":{"default_value":{"export_enabled":true},"pointer":{"export_enabled":true,"data":"/campaigns"}}},"extract_list_1":{"type":"extract_list","logging_enabled":false,"error_rules":[],"x":1417,"y":373,"group":"group_3","inputs":{"pointer":{"export_enabled":true,"data":"/campaign"}}},"fetch_integration_url_v2_2":{"type":"fetch_integration_url_v2","logging_enabled":false,"error_rules":[],"x":854,"y":532,"group":"group_2","inputs":{"headers":{"export_enabled":true},"field":{"export_enabled":true},"all_pages":{"export_enabled":true},"provider":{"export_enabled":true,"data":"snapchat"}}},"patch_json_v3_2":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":608,"y":531,"group":"group_2","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"","value":"https://adsapi.snapchat.com/v1/adaccounts/{{inputValue(\"/id\")}}/adsquads"}]},"data":{"export_enabled":true}}},"extract_v2_2":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":1101,"y":577,"group":"group_2","inputs":{"default_value":{"export_enabled":true,"data":[]},"pointer":{"export_enabled":true,"data":"/adsquads"}}},"concat_1":{"type":"concat","logging_enabled":false,"error_rules":[],"x":352,"y":741,"inputs":{"b":{"export_enabled":true},"schema":{"export_enabled":true,"data":"any"},"concat":{"export_enabled":true}}},"snapchat_fetch_ad_squads_1":{"type":"snapchat_fetch_ad_squads","logging_enabled":false,"error_rules":[],"x":622,"y":834,"inputs":{"ad_account_ids":{"export_enabled":true,"data":[{"id":"8380f9d5-0602-4b9f-9ca7-dc4cc8c4a00f","context":{"ui":{"id":"8380f9d5-0602-4b9f-9ca7-dc4cc8c4a00f","name":"The Giving Movement Trading LLC Self Service"}},"provider":"snapchat","type":"ad_account"}]}}}},"edges":[{"id":"snapchat_select_ad_account_id_1.ad_account_id:patch_json_v3_1.value","points":[]},{"id":"patch_json_v3_1.data:fetch_integration_url_v2_1.url","points":[]},{"id":"patch_json_v3_1.patched:fetch_integration_url_v2_1.fetch","points":[]},{"id":"fetch_integration_url_v2_1.fetched:extract_v2_1.extract","points":[]},{"id":"patch_json_list_v3_1.patched:patch_json_v3_1.patch","points":[]},{"id":"fetch_integration_url_v2_1.body:extract_v2_1.data","points":[]},{"id":"extract_v2_1.data:extract_list_1.data_list","points":[]},{"id":"extract_v2_1.extracted:extract_list_1.extract","points":[]},{"id":"extract_list_1.data_list:patch_json_list_v3_2.data_list","points":[]},{"id":"extract_list_1.extracted:patch_json_list_v3_2.patch","points":[]},{"id":"google_sheets_clear_table_rows_v3_1.cleared:google_sheets_append_table_rows_v3_1.append","points":[]},{"id":"google_sheets_append_table_rows_v3_1.appended:stop_1.stop","points":[]},{"id":"map_any_to_table_rows_1.rows:google_sheets_append_table_rows_v3_1.rows","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id:google_sheets_clear_table_rows_v3_1.spreadsheet_id","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_1.range:google_sheets_clear_table_rows_v3_1.range","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id:google_sheets_append_table_rows_v3_1.spreadsheet_id","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_1.range:google_sheets_append_table_rows_v3_1.range","points":[]},{"id":"map_any_to_table_rows_1.mapped:google_sheets_clear_table_rows_v3_1.clear","points":[]},{"id":"snapchat_select_ad_account_id_1.ad_account_id:concat_1.a","points":[]},{"id":"patch_json_list_v3_1.data_list:join_data_1.a","points":[]},{"id":"patch_json_list_v3_2.data_list:join_data_1.b","points":[]},{"id":"patch_json_list_v3_2.patched:join_data_1.join","points":[]},{"id":"join_data_1.items:sort_1.items","points":[]},{"id":"join_data_1.joined:sort_1.sort","points":[]},{"id":"sort_1.items:map_any_to_table_rows_1.data","points":[]},{"id":"sort_1.sorted:map_any_to_table_rows_1.map","points":[]},{"id":"patch_json_v3_2.data:fetch_integration_url_v2_2.url","points":[]},{"id":"patch_json_v3_2.patched:fetch_integration_url_v2_2.fetch","points":[]},{"id":"snapchat_select_ad_account_id_1.ad_account_id:patch_json_v3_2.value","points":[]},{"id":"fetch_integration_url_v2_2.body:extract_v2_2.data","points":[]},{"id":"fetch_integration_url_v2_2.fetched:extract_v2_2.extract","points":[]},{"id":"extract_v2_2.data:patch_json_list_v3_1.data_list","points":[]},{"id":"extract_v2_2.extracted:patch_json_list_v3_1.patch","points":[]},{"id":"start_1.start:patch_json_v3_2.patch","points":[]}],"groups":{"group_2":{"title":"Fetch Adsquads","description":"","x":609,"y":458,"inputs":["patch_json_v3_2.value","patch_json_v3_2.patch"],"outputs":["patch_json_list_v3_1.patched","patch_json_list_v3_1.data_list"]},"group_1":{"title":"Update Sheet","description":"","x":1418,"y":454,"inputs":["sort_1.items","sort_1.sort"],"outputs":["google_sheets_append_table_rows_v3_1.appended"]},"group_3":{"title":"Fetch Campaigns","description":"","x":859,"y":453,"inputs":["patch_json_v3_1.value","patch_json_v3_1.patch"],"outputs":["patch_json_list_v3_2.data_list","patch_json_list_v3_2.patched"]}},"widgets":{"widget_1":{"title":"Tab","description":"Select or enter the range in the selected spreadsheet in 'A1 notation'","position":2,"input":"google_sheets_select_spreadsheet_id_v2_1.range"},"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":"Ad Account","description":"Selected ad account id","position":0,"input":"snapchat_select_ad_account_id_1.ad_account_id"}},"variables":{},"config":{"capture_inputs_enabled":false,"caching_enabled":false},"tags":[]}

Bulk-upload campaigns, adgroups and ads

{"name":"Bulk-upload Campaigns, Adsets \u0026 Ads","description":"tiktok_bulk_create_ads_20230316","nodes":{"extract_v2_1":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":75,"y":364,"group":"group_1","inputs":{"default_value":{"export_enabled":true},"pointer":{"export_enabled":true,"data":"/campaigns/0/campaign"}}},"patch_json_v3_1":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":633,"y":366,"group":"group_1","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/campaigns/0","value":"{{inputValue(\"\")}}"}]},"data":{"export_enabled":true,"data":{"campaigns":[]}}}},"patch_json_v3_2":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":354,"y":359,"group":"group_1","inputs":{"patches":{"export_enabled":true,"data":[{"op":"remove","path":"/id"},{"op":"remove","path":"/updated_at"},{"op":"remove","path":"/created_at"},{"op":"remove","path":"/delivery_status"},{"op":"remove","path":"/name"},{"op":"add","path":"/name","value":"{{inputValue(\"/config/campaign_name\")}}"},{"op":"remove","path":"/creation_state"}]}}},"post_integration_url_v2_1":{"type":"post_integration_url_v2","logging_enabled":false,"error_rules":[{"error_type":".*","expression":".*"}],"x":424,"y":367,"group":"group_2","inputs":{"headers":{"export_enabled":true},"provider":{"export_enabled":true,"data":"snapchat"}},"outputs":{"error":{"title":"campaign_error","description":"Contains error details"}}},"patch_json_v3_3":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":158,"y":368,"group":"group_2","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"","value":"https://adsapi.snapchat.com/v1/adaccounts/{{inputValue(\"/id\")}}/campaigns"}]},"value":{"title":"ad_account_id","description":"Input any value that can be used in patches"},"data":{"export_enabled":true},"patch":{"title":"patch","description":"Starts the patching"}}},"present_1":{"type":"present","logging_enabled":false,"error_rules":[],"x":3297,"y":1176,"group":"group_3","outputs":{"false":{"title":"next","description":"Triggers if the data does not exist"},"true":{"title":"error - abort","description":"Triggers if the data exists"}}},"extract_v2_2":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":3024,"y":1184,"group":"group_3","inputs":{"default_value":{"export_enabled":true},"pointer":{"export_enabled":true,"data":"/error"}}},"patch_json_v3_4":{"type":"patch_json_v3","title":"Patch JSON - Prepare URL","description":"Applies JSON patches to data","logging_enabled":false,"max_job_retries":1,"timeout":30,"error_rules":[],"x":1433,"y":356,"group":"group_4","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"","value":"{{inputData(\"\")}}{{inputValue(\"/adsquads/0/campaign_id\")}}/adsquads"}]},"data":{"export_enabled":true,"data":"https://adsapi.snapchat.com/v1/campaigns/"}}},"fetch_integration_url_v2_1":{"type":"fetch_integration_url_v2","title":"Fetch Campaign","description":"Executes a GET request to the endpoint of an integration","logging_enabled":false,"max_job_retries":6,"timeout":30,"error_rules":[],"x":995,"y":392,"group":"group_5","inputs":{"headers":{"export_enabled":true},"field":{"export_enabled":true},"all_pages":{"export_enabled":true},"provider":{"export_enabled":true,"data":"snapchat"}}},"patch_json_v3_5":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":748,"y":391,"group":"group_5","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"","value":"{{inputData(\"\")}}{{inputValue(\"\")}}"}]},"data":{"export_enabled":true,"data":"https://adsapi.snapchat.com/v1/campaigns/"}}},"extract_1":{"type":"extract","logging_enabled":false,"error_rules":[],"x":491,"y":391,"group":"group_5","inputs":{"pointer":{"export_enabled":true,"data":"/config/campaign_id"},"extract":{"title":"extract","description":"Starts the extraction"}}},"data_relay_1":{"type":"data_relay","logging_enabled":false,"error_rules":[],"x":29,"y":217,"group":"group_6","inputs":{"data":{"title":"ad_to_be","description":"Data to relay"}}},"slice_list_v3_1":{"type":"slice_list_v3","logging_enabled":false,"error_rules":[],"x":1030,"y":317,"group":"group_7","inputs":{"to":{"export_enabled":true,"data":-1},"from":{"export_enabled":true,"data":3}}},"extract_2":{"type":"extract","logging_enabled":false,"error_rules":[],"x":237,"y":356,"group":"group_8","inputs":{"pointer":{"export_enabled":true,"data":"/config/ad_squad_id"},"extract":{"title":"extract","description":"Starts the extraction"}}},"map_table_rows_1":{"type":"map_table_rows","logging_enabled":false,"error_rules":[],"x":1344,"y":473,"group":"group_7","inputs":{"schema":{"export_enabled":true,"data":"any"}}},"filter_v2_1":{"type":"filter_v2","logging_enabled":false,"error_rules":[],"x":1644,"y":486,"group":"group_7","inputs":{"filters":{"export_enabled":true,"data":[{"value":"create","pointer":"/data/config/ad_action","operator":"="},{"value":null,"pointer":"/data/config/ad_id","operator":"="},{"value":"single_img_vid_webview","pointer":"/data/config/ad_format","operator":"="}]}},"outputs":{"filtered":{"title":"filtered","description":"Triggered when filtered"}}},"patch_json_list_v2_1":{"type":"patch_json_list_v2","logging_enabled":false,"error_rules":[],"x":1917,"y":493,"group":"group_7","inputs":{"patches":{"export_enabled":true,"data":[{"op":"remove","path":"/id/context/ui"}]},"value":{"export_enabled":true}}},"google_sheets_fetch_table_row_mapping_1":{"type":"google_sheets_fetch_table_row_mapping","logging_enabled":false,"error_rules":[],"x":686,"y":550,"group":"group_7"},"for_each_v2_1":{"type":"for_each_v2","title":"For Each","description":"Loops over elements in a list","logging_enabled":false,"error_rules":[],"x":443,"y":275,"inputs":{"next":{"title":"next","description":"Starts the next iteration"},"start":{"title":" start","description":"Starts the first iteration"}},"outputs":{"item":{"title":"ad_row","description":"The current item of the iteration"}}},"google_sheets_fetch_table_rows_v3_1":{"type":"google_sheets_fetch_table_rows_v3","logging_enabled":false,"error_rules":[],"x":427,"y":258,"group":"group_7","inputs":{"date_time_render_option":{"export_enabled":true,"data":"FORMATTED_STRING"},"value_render_option":{"export_enabled":true,"data":"FORMATTED_VALUE"},"dimension":{"export_enabled":true,"data":"ROWS"}}},"google_sheets_select_spreadsheet_id_v2_1":{"type":"google_sheets_select_spreadsheet_id_v2","logging_enabled":false,"error_rules":[],"x":120,"y":394,"group":"group_7","inputs":{"range":{"title":"","description":"The range in A1 notation to fetch"},"spreadsheet_id":{"title":" spreadsheet_id","description":"The spreadsheet to fetch from"}}},"start_1":{"type":"start","title":"Start","description":"Starts an automation","logging_enabled":true,"error_rules":[],"x":5,"y":473},"if_v2_1":{"type":"if_v2","logging_enabled":false,"error_rules":[],"x":1579,"y":429,"group":"group_9","inputs":{"b":{"export_enabled":true,"data":["new_adset_into_above_campaign","new_adset_from_template"]},"condition":{"export_enabled":true,"data":"in"}},"outputs":{"false":{"title":"existing_adset","description":"Triggers when the evaluation is false"},"true":{"title":" new_adset","description":"Triggers when the evaluation is true"}}},"extract_3":{"type":"extract","logging_enabled":false,"error_rules":[],"x":882,"y":332,"group":"group_9","inputs":{"pointer":{"export_enabled":true,"data":"/config/action"}},"outputs":{"data":{"title":"action","description":"The extracted data"}}},"if_v2_2":{"type":"if_v2","logging_enabled":false,"error_rules":[],"x":1229,"y":152,"group":"group_9","inputs":{"b":{"export_enabled":true,"data":"new_campaign_and_adset_from_template"},"condition":{"export_enabled":true,"data":"equal"}},"outputs":{"false":{"title":"existing_campaign","description":"Triggers when the evaluation is false"},"true":{"title":"  new_campaign","description":"Triggers when the evaluation is true"}}},"if_v2_3":{"type":"if_v2","logging_enabled":false,"error_rules":[],"x":932,"y":369,"group":"group_6","inputs":{"b":{"export_enabled":true,"data":["new_campaign_and_adset_from_template","new_adset_into_above_campaign"]},"condition":{"export_enabled":true,"data":"in"},"a":{"title":"action","description":"Write or paste the data A"}}},"fetch_integration_url_v2_2":{"type":"fetch_integration_url_v2","logging_enabled":false,"error_rules":[],"x":757,"y":356,"group":"group_8","inputs":{"headers":{"export_enabled":true},"field":{"export_enabled":true},"all_pages":{"export_enabled":true},"provider":{"export_enabled":true,"data":"snapchat"}}},"patch_json_v3_6":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":493,"y":357,"group":"group_8","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"","value":"{{inputData(\"\")}}{{inputValue(\"\")}}?return_placement_v2=true"}]},"data":{"export_enabled":true,"data":"https://adsapi.snapchat.com/v1/adsquads/"}}},"patch_json_v3_7":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1086,"y":366,"group":"group_10","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/adsquads/0","value":"{{inputValue(\"\")}}"}]},"data":{"export_enabled":true,"data":{"adsquads":[]}}}},"extract_v2_3":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":597,"y":333,"group":"group_9","inputs":{"default_value":{"export_enabled":true},"pointer":{"export_enabled":true,"data":"/data"},"extract":{"title":"extract","description":"Starts the extraction"}},"outputs":{"data":{"title":"ad_to_be","description":"The extracted data"}}},"patch_json_v3_8":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":836,"y":363,"group":"group_10","inputs":{"patches":{"export_enabled":true,"data":[{"op":"remove","path":"/id"},{"op":"remove","path":"/updated_at"},{"op":"remove","path":"/created_at"},{"op":"remove","path":"/delivery_status"},{"op":"remove","path":"/creation_state"},{"op":"remove","path":"/status"},{"op":"remove","path":"/placement"},{"op":"remove","path":"/targeting_reach_status"},{"op":"remove","path":"/targeting/enable_targeting_expansion"},{"op":"remove","path":"/skadnetwork_properties"},{"op":"remove","path":"/delivery_properties_version"},{"op":"remove","path":"/app_install_states"},{"op":"remove","path":"/targeting_reach_status"},{"op":"replace","path":"/name","value":"{{inputValue(\"/config/ad_squad_name\")}}"}]}}},"extract_v2_4":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":565,"y":367,"group":"group_10","inputs":{"default_value":{"export_enabled":true},"pointer":{"export_enabled":true,"data":"/adsquads/0/adsquad"},"data":{"title":"data","description":"Input the source data from which to extract something"}}},"converge_1":{"type":"converge","logging_enabled":false,"error_rules":[],"x":1576,"y":380,"group":"group_6"},"patch_json_v2_1":{"type":"patch_json_v2","logging_enabled":false,"error_rules":[],"x":1207,"y":591,"group":"group_6","inputs":{"patches":{"export_enabled":true,"data":[]},"value":{"export_enabled":true}}},"patch_json_v3_9":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1207,"y":209,"group":"group_6","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/adsquads/0/campaign_id","value":"{{inputValue(\"\")}}"}]},"value":{"title":"campaign_id","description":"A value that can be used in patches"}}},"calculate_math_operation_1":{"type":"calculate_math_operation","logging_enabled":false,"error_rules":[],"x":2080,"y":531,"group":"group_11","inputs":{"operator":{"export_enabled":true,"data":"+"},"b":{"export_enabled":true,"data":60}}},"timestamp_1":{"type":"timestamp","logging_enabled":false,"error_rules":[],"x":1797,"y":539,"group":"group_11","inputs":{"now":{"title":"now","description":"Outputs the current time"}}},"format_timestamp_v2_1":{"type":"format_timestamp_v2","logging_enabled":false,"error_rules":[],"x":2324,"y":554,"group":"group_11","inputs":{"pattern":{"export_enabled":true,"data":"%Y-%m-%dT%H:%M:%S.000Z"}}},"patch_json_v3_10":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":2634,"y":538,"group":"group_11","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/adsquads/0/start_time","value":"{{inputValue(\"\")}}"}]}}},"extract_v2_5":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":1930,"y":365,"group":"group_4","inputs":{"default_value":{"export_enabled":true},"pointer":{"export_enabled":true,"data":"/adsquads/0/adsquad/id"},"extract":{"title":"extract","description":"Starts the extraction"}},"outputs":{"data":{"title":"adset_id","description":"The extracted data"}}},"post_integration_url_v2_2":{"type":"post_integration_url_v2","title":"Create New Ad Squad","description":"Executes a POST request to an endpoint of an integration","logging_enabled":false,"max_job_retries":6,"timeout":30,"error_rules":[{"error_type":".*","expression":".*"}],"x":1677,"y":361,"group":"group_4","inputs":{"headers":{"export_enabled":true},"provider":{"export_enabled":true,"data":"snapchat"}},"outputs":{"error":{"title":"adset_error","description":"Contains error details"}}},"extract_v2_6":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":698,"y":369,"group":"group_2","inputs":{"default_value":{"export_enabled":true},"pointer":{"export_enabled":true,"data":"/campaigns/0/campaign/id"}},"outputs":{"data":{"title":"campaign_id","description":"The extracted data"}}},"data_relay_2":{"type":"data_relay","logging_enabled":false,"error_rules":[],"x":74,"y":351,"group":"group_12","inputs":{"data":{"title":"ad_to_be","description":"Data to relay"}}},"patch_json_v3_11":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1202,"y":1654,"group":"group_3","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/error","value":"{{inputValue('/message')}}"},{"op":"add","path":"/status","value":"Campaign error"}]},"value":{"title":"campaign_error","description":"A value that can be used in patches"},"data":{"export_enabled":true,"data":{}},"patch":{"title":"if_campaign_error","description":"Starts the patching"}}},"patch_json_v3_12":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1199,"y":1364,"group":"group_3","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/error","value":"{{inputValue('/message')}}"},{"op":"add","path":"/status","value":"Ad Creative error"}]},"value":{"title":"ad_creative_error","description":"A value that can be used in patches"},"data":{"export_enabled":true,"data":{}},"patch":{"title":"if_ad_creative_error","description":"Starts the patching"}}},"converge_2":{"type":"converge","logging_enabled":false,"error_rules":[],"x":1520,"y":1131,"group":"group_3"},"patch_json_v3_13":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1190,"y":792,"group":"group_3","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/error","value":"{{inputValue('/message')}}"},{"op":"add","path":"/status","value":"Ad error"}]},"value":{"title":"ad_error","description":"A value that can be used in patches"},"data":{"export_enabled":true,"data":{}},"patch":{"title":"if_ad_error","description":"Starts the patching"}}},"patch_json_v3_14":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1179,"y":1084,"group":"group_3","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/error","value":"{{inputValue('/message')}}"},{"op":"add","path":"/status","value":"Adset error"}]},"value":{"title":"adset_error","description":"A value that can be used in patches"},"data":{"export_enabled":true,"data":{}},"patch":{"title":"if_adset_error","description":"Starts the patching"}}},"patch_json_v3_15":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1183,"y":479,"group":"group_3","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/ad_action","value":" done"},{"op":"add","path":"/ad_id","value":"{{inputValue(\"\")}}"}]},"value":{"title":"ad_id","description":"Input any value that can be used in patches"},"data":{"export_enabled":true,"data":{}},"patch":{"title":"if_ad_created","description":"Starts the patching"}},"outputs":{"data":{"title":"output","description":"The patched data"}}},"stop_1":{"type":"stop","title":"Stop","description":"Stops an automation","logging_enabled":true,"error_rules":[],"x":2260,"y":748},"snapchat_select_ad_account_id_1":{"type":"snapchat_select_ad_account_id","logging_enabled":false,"error_rules":[],"x":655,"y":29,"inputs":{"ad_account_id":{"export_enabled":true}}},"patch_json_v2_2":{"type":"patch_json_v2","logging_enabled":false,"error_rules":[],"x":2160,"y":1118,"group":"group_3","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/0","value":"{{input.value}}"}]},"data":{"title":"data","description":"The data the patches are applied to","export_enabled":true,"data":[]}}},"patch_json_v2_3":{"type":"patch_json_v2","logging_enabled":false,"error_rules":[],"x":1862,"y":1111,"group":"group_3","inputs":{"patches":{"export_enabled":true,"data":[{"op":"remove","path":"/data"},{"op":"add","path":"/data/output","value":"{{input.value}}"},{"op":"add","path":"/data/config/ad_action","value":"{{input.value/status}}"}]},"patch":{"title":"patch","description":"Starts the patching"}}},"unmap_table_rows_1":{"type":"unmap_table_rows","logging_enabled":false,"error_rules":[],"x":2465,"y":1135,"group":"group_3","inputs":{"schema":{"export_enabled":true,"data":"any"}},"outputs":{"unmapped":{"title":"unmapped","description":"Triggered when mapped"}}},"google_sheets_update_table_rows_v2_1":{"type":"google_sheets_update_table_rows_v2","logging_enabled":false,"error_rules":[],"x":2740,"y":1151,"group":"group_3","inputs":{"update":{"title":"update","description":"Starts the update"}}},"data_relay_3":{"type":"data_relay","logging_enabled":false,"error_rules":[],"x":1531,"y":874,"group":"group_3","inputs":{"data":{"title":"ad_row","description":"Data to relay"}}},"patch_json_v3_16":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1141,"y":318,"group":"group_13","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/ads/0/name","value":"{{inputValue(\"/ad_creative/name\")}}"},{"op":"replace","path":"/ads/0/ad_squad_id","value":"{{if(\n    equals(inputValue(\"/config/action\"),\"insert_into_existing_adset\"),\n    inputValue(\"/config/ad_squad_id\"),\n    inputData(\"/ads/0/ad_squad_id\")\n)}}"}]}}},"post_integration_url_v2_3":{"type":"post_integration_url_v2","title":"Create Ad","description":"Executes a POST request to an endpoint of an integration","logging_enabled":false,"max_job_retries":6,"timeout":30,"error_rules":[{"error_type":".*","expression":".*"}],"x":1729,"y":310,"group":"group_13","inputs":{"headers":{"export_enabled":true},"provider":{"export_enabled":true,"data":"snapchat"}},"outputs":{"error":{"title":"ad_error","description":"Contains error details"}}},"data_relay_4":{"type":"data_relay","logging_enabled":false,"error_rules":[],"x":210,"y":596,"group":"group_13","inputs":{"data":{"title":"adset_id","description":"Data to relay"}}},"patch_json_v3_17":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1440,"y":326,"group":"group_13","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"","value":"https://adsapi.snapchat.com/v1/adsquads/{{if(\n    equals(inputData(\"/config/action\"),\"insert_into_existing_adset\"),\n    inputData(\"/config/ad_squad_id\"),\n    inputValue(\"\")\n)}}/ads"}]}}},"patch_json_v3_18":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":512,"y":216,"group":"group_13","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/ads/0/creative_id","value":"{{inputValue(\"/creatives/0/creative/id\")}}"}]},"data":{"export_enabled":true,"data":{"ads":[{"ad_squad_id":"xx","creative_id":"xx","name":"xx","type":"REMOTE_WEBPAGE","status":"PAUSED"}]}},"patch":{"title":"patch","description":"Starts the patching"}}},"patch_json_v3_19":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":874,"y":321,"group":"group_13","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/ads/0/ad_squad_id","value":"{{inputValue(\"\")}}"}]}}},"data_relay_5":{"type":"data_relay","logging_enabled":false,"error_rules":[],"x":131,"y":345,"group":"group_14","inputs":{"data":{"title":"account_id","description":"Data to relay"}}},"data_relay_6":{"type":"data_relay","logging_enabled":false,"error_rules":[],"x":130,"y":627,"group":"group_14","inputs":{"data":{"title":"ad_to_be","description":"Data to relay"}}},"extract_v2_7":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":1154,"y":194,"group":"group_14","inputs":{"default_value":{"export_enabled":true},"pointer":{"export_enabled":true,"data":"/ads/0/ad/id"}},"outputs":{"data":{"title":"ad_id","description":"The extracted data"}}},"patch_json_v3_20":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":209,"y":210,"group":"group_15","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/creatives/0/ad_account_id","value":"{{inputValue(\"/id\")}}"}]},"data":{"export_enabled":true,"data":{"creatives":[{"ad_account_id":"xx","top_snap_media_id":"xx","name":"Creative WV","type":"WEB_VIEW","shareable":true,"call_to_action":"VIEW","web_view_properties":{"url":"xx"},"brand_name":"xx","headline":"xx"}]}},"patch":{"title":"patch","description":"Starts the patching"}}},"patch_json_v3_21":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":770,"y":206,"group":"group_15","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"","value":"{{inputData(\"\")}}{{inputValue(\"/id\")}}/creatives"}]},"data":{"export_enabled":true,"data":"https://adsapi.snapchat.com/v1/adaccounts/"}}},"patch_json_v3_22":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":476,"y":206,"group":"group_15","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/creatives/0/top_snap_media_id","value":"{{inputValue(\"/ad_creative/media_hash\")}}"},{"op":"add","path":"/creatives/0/name","value":"{{inputValue(\"/ad_creative/name\")}}"},{"op":"add","path":"/creatives/0/call_to_action","value":"{{inputValue(\"/ad_creative/call_to_action_type\")}}"},{"op":"add","path":"/creatives/0/web_view_properties/url","value":"{{inputValue(\"/ad_creative/url\")}}"},{"op":"add","path":"/creatives/0/brand_name","value":"{{inputValue(\"/ad_creative/brand_name\")}}"},{"op":"add","path":"/creatives/0/headline","value":"{{inputValue(\"/ad_creative/headline\")}}"}]}}},"post_integration_url_v2_4":{"type":"post_integration_url_v2","title":"Create Ad Creative","description":"Executes a POST request to an endpoint of an integration","logging_enabled":false,"max_job_retries":6,"timeout":30,"error_rules":[{"error_type":".*","expression":".*"}],"x":1022,"y":212,"group":"group_15","inputs":{"headers":{"export_enabled":true},"provider":{"export_enabled":true,"data":"snapchat"},"post":{"title":"post","description":"Starts the request"}},"outputs":{"error":{"title":"ad_creative_error","description":"Contains error details"}}}},"edges":[{"id":"data_relay_6.data:patch_json_v3_17.data","points":[]},{"id":"converge_2.data:extract_v2_2.data","points":[]},{"id":"extract_v2_2.extracted:present_1.check","points":[]},{"id":"google_sheets_update_table_rows_v2_1.updated:extract_v2_2.extract","points":[]},{"id":"extract_v2_2.data:present_1.data","points":[]},{"id":"present_1.false:for_each_v2_1.next","points":[{"x":453,"y":395},{"x":429,"y":395},{"x":429,"y":192},{"x":2170,"y":192},{"x":2191,"y":192},{"x":2191,"y":716},{"x":2191,"y":729}]},{"id":"present_1.true:stop_1.stop","points":[]},{"id":"patch_json_v3_20.data:patch_json_v3_22.data","points":[]},{"id":"patch_json_v3_20.patched:patch_json_v3_22.patch","points":[]},{"id":"patch_json_v3_22.data:post_integration_url_v2_4.body","points":[]},{"id":"patch_json_v3_22.patched:patch_json_v3_21.patch","points":[]},{"id":"patch_json_v3_21.data:post_integration_url_v2_4.url","points":[]},{"id":"patch_json_v3_21.patched:post_integration_url_v2_4.post","points":[]},{"id":"post_integration_url_v2_4.posted:patch_json_v3_18.patch","points":[]},{"id":"patch_json_v3_18.data:patch_json_v3_19.data","points":[]},{"id":"patch_json_v3_18.patched:patch_json_v3_19.patch","points":[]},{"id":"patch_json_v3_19.data:patch_json_v3_16.data","points":[]},{"id":"patch_json_list_v2_1.data_list:for_each_v2_1.items","points":[]},{"id":"patch_json_v3_19.patched:patch_json_v3_16.patch","points":[]},{"id":"patch_json_v3_16.patched:patch_json_v3_17.patch","points":[]},{"id":"patch_json_v3_17.patched:post_integration_url_v2_3.post","points":[]},{"id":"patch_json_v3_16.data:post_integration_url_v2_3.body","points":[]},{"id":"patch_json_v3_17.data:post_integration_url_v2_3.url","points":[]},{"id":"post_integration_url_v2_3.posted:extract_v2_7.extract","points":[]},{"id":"if_v2_1.false:patch_json_v3_20.patch","points":[]},{"id":"patch_json_list_v2_1.patched:for_each_v2_1.start","points":[]},{"id":"extract_v2_3.data:extract_3.data","points":[]},{"id":"extract_v2_3.extracted:extract_3.extract","points":[]},{"id":"for_each_v2_1.do:extract_v2_3.extract","points":[]},{"id":"for_each_v2_1.item:extract_v2_3.data","points":[]},{"id":"extract_v2_3.data:data_relay_2.data","points":[]},{"id":"extract_v2_3.data:data_relay_1.data","points":[]},{"id":"extract_2.data:patch_json_v3_6.value","points":[]},{"id":"snapchat_select_ad_account_id_1.ad_account_id:data_relay_5.data","points":[]},{"id":"data_relay_4.data:patch_json_v3_19.value","points":[]},{"id":"data_relay_4.data:patch_json_v3_17.value","points":[]},{"id":"extract_v2_3.data:data_relay_6.data","points":[]},{"id":"data_relay_6.data:patch_json_v3_22.value","points":[]},{"id":"data_relay_6.data:patch_json_v3_16.value","points":[]},{"id":"google_sheets_fetch_table_rows_v3_1.rows:slice_list_v3_1.data_list","points":[]},{"id":"patch_json_v3_8.data:patch_json_v3_7.value","points":[]},{"id":"fetch_integration_url_v2_2.fetched:extract_v2_4.extract","points":[]},{"id":"fetch_integration_url_v2_2.body:extract_v2_4.data","points":[]},{"id":"data_relay_1.data:patch_json_v3_8.value","points":[]},{"id":"patch_json_v3_7.patched:if_v2_3.evaluate","points":[]},{"id":"patch_json_v3_7.data:patch_json_v3_9.data","points":[]},{"id":"patch_json_v3_7.data:patch_json_v2_1.data","points":[]},{"id":"if_v2_3.true:patch_json_v3_9.patch","points":[]},{"id":"if_v2_3.false:patch_json_v2_1.patch","points":[]},{"id":"patch_json_v3_9.data:converge_1.data","points":[]},{"id":"patch_json_v2_1.data:converge_1.data","points":[]},{"id":"patch_json_v2_1.patched:converge_1.converge","points":[]},{"id":"patch_json_v3_9.patched:converge_1.converge","points":[]},{"id":"timestamp_1.timestamp:calculate_math_operation_1.a","points":[]},{"id":"timestamp_1.done:calculate_math_operation_1.calculate","points":[]},{"id":"converge_1.converged:timestamp_1.now","points":[]},{"id":"calculate_math_operation_1.data:format_timestamp_v2_1.timestamp","points":[]},{"id":"calculate_math_operation_1.calculated:format_timestamp_v2_1.format","points":[]},{"id":"format_timestamp_v2_1.formatted:patch_json_v3_10.patch","points":[]},{"id":"format_timestamp_v2_1.date_time:patch_json_v3_10.value","points":[]},{"id":"converge_1.data:patch_json_v3_10.data","points":[]},{"id":"patch_json_v3_10.data:post_integration_url_v2_2.body","points":[]},{"id":"post_integration_url_v2_2.body:extract_v2_5.data","points":[]},{"id":"extract_v2_5.extracted:patch_json_v3_20.patch","points":[]},{"id":"post_integration_url_v2_4.body:patch_json_v3_18.value","points":[]},{"id":"post_integration_url_v2_3.body:extract_v2_7.data","points":[]},{"id":"if_v2_1.true:extract_2.extract","points":[]},{"id":"patch_json_v3_10.patched:patch_json_v3_4.patch","points":[]},{"id":"converge_1.data:patch_json_v3_4.value","points":[]},{"id":"patch_json_v3_4.data:post_integration_url_v2_2.url","points":[]},{"id":"patch_json_v3_4.patched:post_integration_url_v2_2.post","points":[]},{"id":"patch_json_v3_3.data:post_integration_url_v2_1.url","points":[]},{"id":"patch_json_v3_2.data:patch_json_v3_1.value","points":[]},{"id":"patch_json_v3_2.patched:patch_json_v3_1.patch","points":[]},{"id":"patch_json_v3_3.patched:post_integration_url_v2_1.post","points":[]},{"id":"post_integration_url_v2_1.posted:extract_v2_6.extract","points":[]},{"id":"extract_v2_6.data:patch_json_v3_9.value","points":[]},{"id":"snapchat_select_ad_account_id_1.ad_account_id:patch_json_v3_3.value","points":[]},{"id":"extract_v2_1.data:patch_json_v3_2.data","points":[]},{"id":"extract_v2_1.extracted:patch_json_v3_2.patch","points":[]},{"id":"data_relay_2.data:patch_json_v3_2.value","points":[]},{"id":"post_integration_url_v2_1.body:extract_v2_6.data","points":[]},{"id":"extract_v2_6.extracted:extract_2.extract","points":[]},{"id":"extract_v2_5.data:data_relay_4.data","points":[]},{"id":"patch_json_v3_1.patched:patch_json_v3_3.patch","points":[]},{"id":"data_relay_5.data:patch_json_v3_21.value","points":[]},{"id":"data_relay_5.data:patch_json_v3_20.value","points":[]},{"id":"data_relay_3.data:patch_json_v2_3.data","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":"patch_json_v2_2.patched:unmap_table_rows_1.unmap","points":[]},{"id":"patch_json_v2_2.data:unmap_table_rows_1.mapped_rows","points":[]},{"id":"unmap_table_rows_1.rows:google_sheets_update_table_rows_v2_1.rows","points":[]},{"id":"converge_2.converged:patch_json_v2_3.patch","points":[]},{"id":"converge_2.data:patch_json_v2_3.value","points":[]},{"id":"patch_json_v3_15.data:converge_2.data","points":[]},{"id":"patch_json_v3_13.patched:converge_2.converge","points":[]},{"id":"patch_json_v3_13.data:converge_2.data","points":[]},{"id":"patch_json_v3_15.patched:converge_2.converge","points":[]},{"id":"patch_json_v3_14.patched:converge_2.converge","points":[]},{"id":"patch_json_v3_14.data:converge_2.data","points":[]},{"id":"unmap_table_rows_1.unmapped:google_sheets_update_table_rows_v2_1.update","points":[]},{"id":"extract_v2_7.data:patch_json_v3_15.value","points":[]},{"id":"google_sheets_fetch_table_row_mapping_1.mapping:unmap_table_rows_1.mapping","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id:google_sheets_update_table_rows_v2_1.spreadsheet_id","points":[]},{"id":"patch_json_v3_11.data:converge_2.data","points":[]},{"id":"patch_json_v3_1.data:post_integration_url_v2_1.body","points":[]},{"id":"patch_json_v3_11.patched:converge_2.converge","points":[]},{"id":"extract_v2_7.extracted:patch_json_v3_15.patch","points":[]},{"id":"post_integration_url_v2_4.failed:patch_json_v3_12.patch","points":[]},{"id":"post_integration_url_v2_1.failed:patch_json_v3_11.patch","points":[]},{"id":"post_integration_url_v2_3.error:patch_json_v3_13.value","points":[]},{"id":"post_integration_url_v2_2.error:patch_json_v3_14.value","points":[]},{"id":"post_integration_url_v2_1.error:patch_json_v3_11.value","points":[]},{"id":"patch_json_v3_12.data:converge_2.data","points":[]},{"id":"patch_json_v3_12.patched:converge_2.converge","points":[]},{"id":"post_integration_url_v2_3.failed:patch_json_v3_13.patch","points":[]},{"id":"post_integration_url_v2_2.failed:patch_json_v3_14.patch","points":[]},{"id":"post_integration_url_v2_4.error:patch_json_v3_12.value","points":[]},{"id":"for_each_v2_1.item:data_relay_3.data","points":[]},{"id":"map_table_rows_1.mapped_rows:filter_v2_1.items","points":[]},{"id":"start_1.start:google_sheets_fetch_table_rows_v3_1.fetch","points":[]},{"id":"for_each_v2_1.done:stop_1.stop","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id:google_sheets_fetch_table_rows_v3_1.spreadsheet_id","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_1.range:google_sheets_fetch_table_rows_v3_1.range","points":[]},{"id":"extract_3.data:if_v2_2.a","points":[]},{"id":"extract_3.data:if_v2_1.a","points":[]},{"id":"extract_3.extracted:if_v2_2.evaluate","points":[]},{"id":"if_v2_2.false:if_v2_1.evaluate","points":[]},{"id":"extract_3.data:if_v2_3.a","points":[]},{"id":"data_relay_2.data:extract_1.data","points":[]},{"id":"data_relay_1.data:extract_2.data","points":[]},{"id":"if_v2_2.true:extract_1.extract","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id:google_sheets_fetch_table_row_mapping_1.spreadsheet_id","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:slice_list_v3_1.slice","points":[]},{"id":"slice_list_v3_1.sliced:map_table_rows_1.map","points":[]},{"id":"map_table_rows_1.mapped:filter_v2_1.filter","points":[]},{"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":"google_sheets_select_spreadsheet_id_v2_1.range:google_sheets_fetch_table_row_mapping_1.range","points":[]},{"id":"slice_list_v3_1.data_list:map_table_rows_1.rows","points":[]},{"id":"google_sheets_fetch_table_rows_v3_1.fetched:google_sheets_fetch_table_row_mapping_1.fetch","points":[]},{"id":"extract_1.data:patch_json_v3_5.value","points":[]},{"id":"extract_1.extracted:patch_json_v3_5.patch","points":[]},{"id":"patch_json_v3_5.data:fetch_integration_url_v2_1.url","points":[]},{"id":"patch_json_v3_5.patched:fetch_integration_url_v2_1.fetch","points":[]},{"id":"fetch_integration_url_v2_1.body:extract_v2_1.data","points":[]},{"id":"fetch_integration_url_v2_1.fetched:extract_v2_1.extract","points":[]},{"id":"extract_2.extracted:patch_json_v3_6.patch","points":[]},{"id":"patch_json_v3_6.data:fetch_integration_url_v2_2.url","points":[]},{"id":"patch_json_v3_6.patched:fetch_integration_url_v2_2.fetch","points":[]},{"id":"extract_v2_4.data:patch_json_v3_8.data","points":[]},{"id":"extract_v2_4.extracted:patch_json_v3_8.patch","points":[]},{"id":"patch_json_v3_8.patched:patch_json_v3_7.patch","points":[]},{"id":"post_integration_url_v2_2.posted:extract_v2_5.extract","points":[]}],"groups":{"group_8":{"title":"Fetch Adset","description":"","x":348,"y":384,"group":"group_6","inputs":["extract_2.data","extract_2.extract"],"outputs":["fetch_integration_url_v2_2.fetched","fetch_integration_url_v2_2.body"]},"group_15":{"title":"Create Ad Creative","description":"","x":621,"y":193,"group":"group_14","inputs":["patch_json_v3_20.value","patch_json_v3_20.patch","patch_json_v3_22.value","patch_json_v3_21.value"],"outputs":["post_integration_url_v2_4.body","post_integration_url_v2_4.posted","post_integration_url_v2_4.error","post_integration_url_v2_4.failed"]},"group_13":{"title":"Create Ad","description":"","x":891,"y":196,"group":"group_14","inputs":["data_relay_4.data","patch_json_v3_16.value","patch_json_v3_18.value","patch_json_v3_18.patch","patch_json_v3_17.data"],"outputs":["post_integration_url_v2_3.posted","post_integration_url_v2_3.body","post_integration_url_v2_3.error","post_integration_url_v2_3.failed"]},"group_12":{"title":"Create Campaign","description":"","x":1081,"y":230,"inputs":["data_relay_2.data","extract_1.extract","patch_json_v3_3.value"],"outputs":["extract_v2_6.data","extract_v2_6.extracted","post_integration_url_v2_1.failed","post_integration_url_v2_1.error"]},"group_9":{"title":"Control Flow","description":"","x":752,"y":296,"inputs":["extract_v2_3.extract","extract_v2_3.data"],"outputs":["if_v2_2.true","extract_3.data","if_v2_1.false","if_v2_1.true","extract_v2_3.data"]},"group_14":{"title":"Create Ad","description":"","x":1680,"y":226,"inputs":["data_relay_5.data","patch_json_v3_20.patch","data_relay_4.data","data_relay_6.data"],"outputs":["extract_v2_7.extracted","extract_v2_7.data","post_integration_url_v2_3.failed","post_integration_url_v2_3.error","post_integration_url_v2_4.error","post_integration_url_v2_4.failed"]},"group_16":{"title":"Create PAC Video Ad","description":"","x":4705,"y":2987},"group_17":{"title":"Create PAC Video Ad","description":"","x":4352,"y":2997},"group_7":{"title":"Get Spreadsheet data \u0026 validate","description":"","x":144,"y":404,"inputs":["google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id","google_sheets_fetch_table_rows_v3_1.fetch","google_sheets_select_spreadsheet_id_v2_1.range"],"outputs":["google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id","patch_json_list_v2_1.data_list","patch_json_list_v2_1.patched","google_sheets_fetch_table_row_mapping_1.mapping"]},"group_6":{"title":"Create Adset","description":"","x":1381,"y":229,"inputs":["if_v2_3.a","data_relay_1.data","patch_json_v3_9.value","extract_2.extract"],"outputs":["extract_v2_5.data","extract_v2_5.extracted","post_integration_url_v2_2.error","post_integration_url_v2_2.failed"]},"group_3":{"title":"Update Sheet","description":"","x":1944,"y":236,"inputs":["unmap_table_rows_1.mapping","google_sheets_update_table_rows_v2_1.spreadsheet_id","data_relay_3.data","patch_json_v3_13.patch","patch_json_v3_13.value","patch_json_v3_14.patch","patch_json_v3_14.value","patch_json_v3_11.patch","patch_json_v3_15.patch","patch_json_v3_15.value","patch_json_v3_12.patch","patch_json_v3_12.value","patch_json_v3_11.value"],"outputs":["present_1.true","present_1.false"]},"group_10":{"title":"Prepare New Adset","description":"","x":619,"y":384,"group":"group_6","inputs":["patch_json_v3_8.value","extract_v2_4.data","extract_v2_4.extract"],"outputs":["patch_json_v3_7.patched","patch_json_v3_7.data"]},"group_11":{"title":"Add new Start time","description":"","x":1189,"y":361,"group":"group_4","inputs":["timestamp_1.now","patch_json_v3_10.data"],"outputs":["patch_json_v3_10.data","patch_json_v3_10.patched"]},"group_4":{"title":"Create New Adset","description":"","x":1837,"y":385,"group":"group_6","inputs":["patch_json_v3_4.value","patch_json_v3_10.data","timestamp_1.now"],"outputs":["extract_v2_5.extracted","extract_v2_5.data","post_integration_url_v2_2.error","post_integration_url_v2_2.failed"]},"group_5":{"title":"Fetch Campaign","description":"","x":354,"y":314,"group":"group_12","inputs":["extract_1.data","extract_1.extract"],"outputs":["fetch_integration_url_v2_1.fetched","fetch_integration_url_v2_1.body"]},"group_2":{"title":"Create Campaign","description":"","x":999,"y":380,"group":"group_12","inputs":["patch_json_v3_3.value","patch_json_v3_3.patch","post_integration_url_v2_1.body"],"outputs":["extract_v2_6.data","extract_v2_6.extracted","post_integration_url_v2_1.failed","post_integration_url_v2_1.error"]},"group_1":{"title":"Prepare New Campaign","description":"","x":653,"y":457,"group":"group_12","inputs":["extract_v2_1.data","extract_v2_1.extract","patch_json_v3_2.value"],"outputs":["patch_json_v3_1.data","patch_json_v3_1.patched"]}},"widgets":{"widget_1":{"title":"Ad Account","description":"Selected ad account id","position":0,"input":"snapchat_select_ad_account_id_1.ad_account_id"},"widget_2":{"title":"Spreadsheet","description":"The spreadsheet to fetch from","position":2,"input":"google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id"},"widget_3":{"title":"Tab","description":"The range in A1 notation to fetch","position":2,"input":"google_sheets_select_spreadsheet_id_v2_1.range"}},"variables":{},"config":{"capture_inputs_enabled":false,"caching_enabled":false},"tags":[]}