TikTok Bulk Ad Uploading

Export Videos from TikTok to sheet

{"name":"Export Existing TikTok Videos ","description":"tiktok_export_videos_20230316","nodes":{"start_1":{"type":"start","logging_enabled":false,"error_rules":[],"x":155,"y":207},"tik_tok_select_ad_account_id_1":{"type":"tik_tok_select_ad_account_id","logging_enabled":false,"error_rules":[],"x":51,"y":306,"inputs":{"ad_account_id":{"title":"ad_account_id","description":"Select one TikTok Ad Account"}}},"map_any_to_table_rows_1":{"type":"map_any_to_table_rows","logging_enabled":false,"error_rules":[],"x":1908,"y":272,"inputs":{"add_header":{"export_enabled":true,"data":true},"mapping":{"export_enabled":true,"data":{"A":"/file_name","B":"/format","C":"/video_id","D":"/thumbnail_id","E":"/video_cover_url"}},"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":2203,"y":315,"inputs":{"range":{"title":"range","description":"Input the range to search for the table to append to"},"spreadsheet_id":{"title":"spreadsheet_id","description":"Select a Google Spreadsheet file to append data to"}}},"stop_1":{"type":"stop","logging_enabled":false,"error_rules":[],"x":2077,"y":566},"tik_tok_fetch_ad_videos_v2_1":{"type":"tik_tok_fetch_ad_videos_v2","title":"Fetch TikTok AdVideos","description":"Fetches ad_videos for selected ad account and operational status","logging_enabled":false,"max_job_retries":6,"timeout":90,"error_rules":[],"x":344,"y":258},"replace_list_string_1":{"type":"replace_list_string","logging_enabled":false,"error_rules":[],"x":905,"y":237,"inputs":{"value":{"export_enabled":true,"data":""},"regex":{"export_enabled":true,"data":"http://p16-sign-sg.tiktokcdn.com/"},"pointer":{"export_enabled":true,"data":"/thumbnail_id"},"schema":{"export_enabled":true,"data":"any"}}},"patch_json_list_v2_1":{"type":"patch_json_list_v2","logging_enabled":false,"error_rules":[],"x":612,"y":273,"inputs":{"patches":{"export_enabled":true,"data":[{"op":"copy","path":"/thumbnail_id","from":"/video_cover_url"}]},"value":{"export_enabled":true}}},"replace_list_string_2":{"type":"replace_list_string","logging_enabled":false,"error_rules":[],"x":1191,"y":246,"inputs":{"value":{"export_enabled":true,"data":""},"regex":{"export_enabled":true,"data":"~.*"},"pointer":{"export_enabled":true,"data":"/thumbnail_id"},"schema":{"export_enabled":true,"data":"any"}}},"filter_v2_1":{"type":"filter_v2","logging_enabled":false,"error_rules":[],"x":1540,"y":256,"inputs":{"filters":{"export_enabled":true}}}},"edges":[{"id":"map_any_to_table_rows_1.rows:google_sheets_append_table_rows_v3_1.rows","points":[]},{"id":"google_sheets_append_table_rows_v3_1.appended:stop_1.stop","points":[]},{"id":"replace_list_string_1.data_list:replace_list_string_2.data_list","points":[]},{"id":"patch_json_list_v2_1.data_list:replace_list_string_1.data_list","points":[]},{"id":"patch_json_list_v2_1.patched:replace_list_string_1.replace","points":[]},{"id":"replace_list_string_1.replaced:replace_list_string_2.replace","points":[]},{"id":"tik_tok_select_ad_account_id_1.ad_account_id:tik_tok_fetch_ad_videos_v2_1.ad_account_id","points":[]},{"id":"tik_tok_fetch_ad_videos_v2_1.ad_videos:patch_json_list_v2_1.data_list","points":[]},{"id":"tik_tok_fetch_ad_videos_v2_1.fetched:patch_json_list_v2_1.patch","points":[]},{"id":"start_1.start:tik_tok_fetch_ad_videos_v2_1.fetch","points":[]},{"id":"map_any_to_table_rows_1.mapped:google_sheets_append_table_rows_v3_1.append","points":[]},{"id":"replace_list_string_2.replaced:filter_v2_1.filter","points":[]},{"id":"filter_v2_1.items:map_any_to_table_rows_1.data","points":[]},{"id":"filter_v2_1.filtered:map_any_to_table_rows_1.map","points":[]},{"id":"replace_list_string_2.data_list:filter_v2_1.items","points":[]}],"groups":{},"widgets":{"widget_1":{"title":"Filter","description":"Add filters that will be applied to the items","position":10,"input":"filter_v2_1.filters"},"widget_2":{"title":"Ad Account","description":"Select one TikTok Ad Account","position":0,"input":"tik_tok_select_ad_account_id_1.ad_account_id"},"widget_3":{"title":"Tab / Range","description":"Select a tab or enter the range in A1 notation.","position":2,"icon":"las la-table","input":"google_sheets_append_table_rows_v3_1.range"},"widget_4":{"title":"Spreadsheet","description":"Select a Google Spreadsheet file to add the identities data to.","position":1,"input":"google_sheets_append_table_rows_v3_1.spreadsheet_id"}},"variables":{},"config":{"capture_inputs_enabled":false,"caching_enabled":false},"tags":[]}

Export ad groups to sheet

{"name":"Export AdGroups & Campaigns","description":"tiktok_export_adgroups_20230316","nodes":{"start_1":{"type":"start","logging_enabled":false,"x":155,"y":207},"tik_tok_select_ad_account_id_1":{"type":"tik_tok_select_ad_account_id","logging_enabled":false,"x":84,"y":282,"inputs":{"ad_account_id":{"title":"ad_account_id","description":"Select one TikTok Ad Account"}}},"tik_tok_fetch_ad_groups_1":{"type":"tik_tok_fetch_ad_groups_v2","logging_enabled":false,"x":424,"y":214,"inputs":{"operational_status":{"export_enabled":true,"data":"ALL"}}},"map_any_to_table_rows_1":{"type":"map_any_to_table_rows","logging_enabled":false,"x":739,"y":197,"inputs":{"mapping":{"export_enabled":true,"data":{"A":"/adgroup_id","B":"/adgroup_name","C":"/campaign_id","D":"/campaign_name"}},"add_header":{"export_enabled":true},"schema":{"export_enabled":true,"data":"any_list"}}},"stop_1":{"type":"stop","logging_enabled":false,"x":1432,"y":447},"google_sheets_append_table_rows_v3_1":{"type":"google_sheets_append_table_rows_v3","logging_enabled":false,"x":1064,"y":245,"inputs":{"range":{"title":"range","description":"Input the range to search for the table to append to"},"spreadsheet_id":{"title":"spreadsheet_id","description":"Select a Google Spreadsheet file to append data to"}}}},"edges":["google_sheets_append_table_rows_v3_1.appended:stop_1.stop","map_any_to_table_rows_1.mapped:google_sheets_append_table_rows_v3_1.append","map_any_to_table_rows_1.rows:google_sheets_append_table_rows_v3_1.rows","tik_tok_fetch_ad_groups_1.ad_groups:map_any_to_table_rows_1.data","start_1.start:tik_tok_fetch_ad_groups_1.fetch","tik_tok_select_ad_account_id_1.ad_account_id:tik_tok_fetch_ad_groups_1.ad_account_id","tik_tok_fetch_ad_groups_1.fetched:map_any_to_table_rows_1.map"],"groups":{},"widgets":{"widget_1":{"title":"Ad Account","description":"Select one TikTok Ad Account","position":0,"input":"tik_tok_select_ad_account_id_1.ad_account_id"},"widget_2":{"title":"Tab / Range","description":"Select a tab or enter the range in A1 notation.","position":2,"icon":"las la-table","input":"google_sheets_append_table_rows_v3_1.range"},"widget_3":{"title":"Spreadsheet","description":"Select a Google Spreadsheet file to add the identities data to.","position":1,"input":"google_sheets_append_table_rows_v3_1.spreadsheet_id"}},"variables":{},"config":{"capture_inputs_enabled":false,"caching_enabled":false},"tags":[]}

Export identities to sheet

{"name":"Export TikTok Identities","description":"tiktok_export_identities_20230316","nodes":{"start_1":{"type":"start","logging_enabled":false,"x":155,"y":207},"stop_1":{"type":"stop","logging_enabled":false,"x":1260,"y":609},"tik_tok_select_ad_account_id_1":{"type":"tik_tok_select_ad_account_id","logging_enabled":false,"x":51,"y":306,"inputs":{"ad_account_id":{"title":"ad_account_id","description":"Select one TikTok Ad Account"}}},"map_any_to_table_rows_1":{"type":"map_any_to_table_rows","logging_enabled":false,"x":688,"y":280,"inputs":{"mapping":{"export_enabled":true,"data":{"A":"/display_name","B":"/identity_id","C":"/identity_type","D":"/profile_image"}},"schema":{"export_enabled":true,"data":"any_list"},"add_header":{"export_enabled":true}}},"tik_tok_fetch_identities_1":{"type":"tik_tok_fetch_identities","logging_enabled":false,"x":413,"y":236},"google_sheets_append_table_rows_v3_1":{"type":"google_sheets_append_table_rows_v3","logging_enabled":false,"x":973,"y":345,"inputs":{"range":{"title":"range","description":"Input the range to search for the table to append to"},"spreadsheet_id":{"title":"spreadsheet_id","description":"Select a Google Spreadsheet file to append data to"}}}},"edges":["google_sheets_append_table_rows_v3_1.appended:stop_1.stop","map_any_to_table_rows_1.mapped:google_sheets_append_table_rows_v3_1.append","map_any_to_table_rows_1.rows:google_sheets_append_table_rows_v3_1.rows","tik_tok_select_ad_account_id_1.ad_account_id:tik_tok_fetch_identities_1.ad_account_id","start_1.start:tik_tok_fetch_identities_1.fetch","tik_tok_fetch_identities_1.identities:map_any_to_table_rows_1.data","tik_tok_fetch_identities_1.fetched:map_any_to_table_rows_1.map"],"groups":{},"widgets":{"widget_1":{"title":"Ad Account","description":"Select one TikTok Ad Account","position":0,"input":"tik_tok_select_ad_account_id_1.ad_account_id"},"widget_2":{"title":"Tab / Range","description":"Select a tab or enter the range in A1 notation.","position":2,"icon":"las la-table","input":"google_sheets_append_table_rows_v3_1.range"},"widget_3":{"title":"Spreadsheet","description":"Select a Google Spreadsheet file to add the identities data to.","position":1,"input":"google_sheets_append_table_rows_v3_1.spreadsheet_id"}},"variables":{},"config":{"capture_inputs_enabled":false,"caching_enabled":false},"tags":[]}

Bulk-upload campaigns, adgroups and ads

{"name":"Bulk-upload Campaigns, Adgroups & Single Video Ads (TikTok)","description":"tiktok_bulk_create_ads_20230316","nodes":{"extract_1":{"type":"extract_v2","logging_enabled":false,"x":271,"y":606,"group":"group_1","inputs":{"pointer":{"export_enabled":true,"data":"/config/campaign_id"}}},"tik_tok_select_ad_account_id_1":{"type":"tik_tok_select_ad_account_id","logging_enabled":false,"x":846,"y":49,"inputs":{"ad_account_id":{"export_enabled":true,"data":{"id":"7153616368384933889","context":{"ui":{"id":"7153616368384933889","name":"lt_SocialTech - Livebeam3 - Httpool"}},"provider":"tik_tok","type":"ad_account"}}}},"data_relay_1":{"type":"data_relay","logging_enabled":false,"x":17,"y":472,"group":"group_1","inputs":{"data":{"title":"ad_to_be","description":"Data to relay"}}},"data_relay_2":{"type":"data_relay","logging_enabled":false,"x":29,"y":217,"group":"group_2","inputs":{"data":{"title":"ad_to_be","description":"Data to relay"}}},"extract_2":{"type":"extract_v2","logging_enabled":false,"x":606,"y":300,"group":"group_3","inputs":{"pointer":{"export_enabled":true,"data":"/config/adgroup_id"}}},"tik_tok_fetch_campaign_1":{"type":"tik_tok_fetch_campaign","logging_enabled":false,"x":845,"y":611,"group":"group_1"},"parse_string_to_id_1":{"type":"parse_string_to_id","logging_enabled":false,"x":545,"y":611,"group":"group_1"},"tik_tok_select_ad_account_id_2":{"type":"tik_tok_select_ad_account_id","title":"Relay TikTok Ad Account Id","description":"Selects ad account id from a list of options","logging_enabled":false,"max_job_retries":6,"timeout":30,"x":93,"y":829,"group":"group_1"},"tik_tok_create_ad_group_1":{"type":"tik_tok_create_ad_group","logging_enabled":false,"x":3220,"y":567,"group":"group_2"},"input_any_1":{"type":"input_any","title":"Schema Overwrite","description":"Allows to input a any type","logging_enabled":false,"max_job_retries":6,"timeout":30,"x":561,"y":403,"group":"group_1","inputs":{"any":{"export_enabled":true,"data":"tik_tok_campaign_id"}}},"tik_tok_create_campaign_1":{"type":"tik_tok_create_campaign","logging_enabled":false,"x":1739,"y":646,"group":"group_1"},"tik_tok_select_ad_account_id_3":{"type":"tik_tok_select_ad_account_id","title":"Relay TikTok Ad Account Id","description":"Selects ad account id from a list of options","logging_enabled":false,"max_job_retries":6,"timeout":30,"x":110,"y":681,"group":"group_2","inputs":{"ad_account_id":{"title":" ad_account_id","description":"Select one TikTok Ad Account"}}},"parse_string_to_id_2":{"type":"parse_string_to_id","logging_enabled":false,"x":939,"y":483,"group":"group_3"},"input_any_2":{"type":"input_any","logging_enabled":false,"x":429,"y":532,"group":"group_3","inputs":{"any":{"export_enabled":true,"data":"tik_tok_ad_group_id"}}},"tik_tok_select_ad_account_id_4":{"type":"tik_tok_select_ad_account_id","title":"Relay TikTok Ad Account Id","description":"Selects ad account id from a list of options","logging_enabled":false,"max_job_retries":6,"timeout":30,"x":218,"y":560,"group":"group_4","inputs":{"ad_account_id":{"title":" ad_account_id","description":"Select one TikTok Ad Account"}}},"tik_tok_fetch_ad_group_1":{"type":"tik_tok_fetch_ad_group","logging_enabled":false,"x":562,"y":376,"group":"group_2"},"extract_v2_1":{"type":"extract_v2","logging_enabled":false,"x":489,"y":218,"group":"group_5","inputs":{"data":{"title":"ad_row","description":"The data from which to extract"},"pointer":{"export_enabled":true,"data":"/data"},"default_value":{"export_enabled":true}},"outputs":{"data":{"title":"ad_to_be","description":"The extracted data"}}},"google_sheets_update_table_rows_v2_1":{"type":"google_sheets_update_table_rows_v2","logging_enabled":false,"x":1479,"y":351,"group":"group_6"},"slice_list_v3_1":{"type":"slice_list_v3","logging_enabled":false,"x":1030,"y":317,"group":"group_7","inputs":{"to":{"export_enabled":true,"data":-1},"from":{"export_enabled":true,"data":3}}},"unmap_table_rows_1":{"type":"unmap_table_rows","logging_enabled":false,"x":1121,"y":318,"group":"group_6","inputs":{"schema":{"export_enabled":true,"data":"any"}}},"patch_json_v2_1":{"type":"patch_json_v2","logging_enabled":false,"x":497,"y":337,"group":"group_6","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/data","value":{}},{"op":"add","path":"/data/config/ad_id","value":"{{input.value/id}}"},{"op":"add","path":"/data/config/ad_action","value":"done"}]},"data":{"title":"ad_row","description":"The data the patches are applied to"}}},"map_table_rows_1":{"type":"map_table_rows","logging_enabled":false,"x":1344,"y":473,"group":"group_7","inputs":{"schema":{"export_enabled":true,"data":"any"}}},"filter_v2_1":{"type":"filter_v2","logging_enabled":false,"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_VIDEO","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,"x":1921,"y":490,"group":"group_7","inputs":{"patches":{"export_enabled":true,"data":[{"op":"remove","path":"/id/context/ui"}]},"value":{"export_enabled":true}}},"patch_json_v2_2":{"type":"patch_json_v2","logging_enabled":false,"x":775,"y":337,"group":"group_6","inputs":{"value":{"title":"table_row","description":"A value that can be used in patches"},"patches":{"export_enabled":true,"data":[{"op":"add","path":"/-","value":"{{input.value}}"}]},"data":{"export_enabled":true,"data":[]}}},"google_sheets_fetch_table_row_mapping_1":{"type":"google_sheets_fetch_table_row_mapping","logging_enabled":false,"x":686,"y":550,"group":"group_7"},"patch_json_v2_3":{"type":"patch_json_v2","logging_enabled":false,"x":1423,"y":592,"group":"group_1","inputs":{"patches":{"export_enabled":true,"data":[{"op":"test","path":"/budget","value":0},{"op":"remove","path":"/budget"}]},"value":{"export_enabled":true}}},"converge_1":{"type":"converge","logging_enabled":false,"x":1756,"y":469,"group":"group_2"},"format_timestamp_v2_1":{"type":"format_timestamp_v2","logging_enabled":false,"x":2588,"y":457,"group":"group_2","inputs":{"pattern":{"export_enabled":true,"data":"%Y-%m-%d %H:%M:%S"}}},"extract_v2_2":{"type":"extract_v2","logging_enabled":false,"x":3557,"y":507,"group":"group_2","inputs":{"pointer":{"export_enabled":true,"data":"/id"},"default_value":{"export_enabled":true}},"outputs":{"data":{"title":"adgroup_id","description":"The extracted data"}}},"calculate_math_operation_1":{"type":"calculate_math_operation","logging_enabled":false,"x":2331,"y":453,"group":"group_2","inputs":{"operator":{"export_enabled":true,"data":"+"},"b":{"export_enabled":true,"data":60}}},"tik_tok_create_ad_1":{"type":"tik_tok_create_ad","logging_enabled":false,"x":1426,"y":621,"group":"group_4"},"for_each_v2_1":{"type":"for_each_v2","title":"For Each","description":"Loops over elements in a list","logging_enabled":false,"x":444,"y":273,"inputs":{"start":{"title":" start","description":"Starts the first iteration"},"next":{"title":"next","description":"Starts the next iteration"}},"outputs":{"item":{"title":"ad_row","description":"The current item of the iteration"}}},"data_relay_3":{"type":"data_relay","logging_enabled":false,"x":88,"y":192,"group":"group_6","inputs":{"data":{"title":"ad_id","description":"Data to relay"}}},"google_sheets_fetch_table_rows_v3_1":{"type":"google_sheets_fetch_table_rows_v3","logging_enabled":false,"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,"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"}}},"stop_1":{"type":"stop","title":"Stop","description":"Stops an automation","logging_enabled":true,"x":796,"y":815},"start_1":{"type":"start","title":"Start","description":"Starts an automation","logging_enabled":true,"x":5,"y":464},"patch_json_v2_4":{"type":"patch_json_v2","logging_enabled":false,"x":1125,"y":590,"group":"group_1","inputs":{"patches":{"export_enabled":true,"data":[{"op":"remove","path":"/campaign_id"},{"op":"replace","path":"/campaign_name","value":"{{input.value/config/campaign_name}}"},{"op":"remove","path":"/deep_bid_type"},{"op":"remove","path":"/roas_bid"},{"op":"remove","path":"/app_promotion_type"},{"op":"remove","path":"/create_time"},{"op":"remove","path":"/modify_time"},{"op":"remove","path":"/advertiser_id"}]}}},"timestamp_1":{"type":"timestamp","logging_enabled":false,"x":2048,"y":461,"group":"group_2"},"patch_json_v2_5":{"type":"patch_json_v2","logging_enabled":false,"x":2855,"y":442,"group":"group_2","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/schedule_start_time","value":"{{input.value}}"}]}},"outputs":{"patched":{"title":"patched","description":"Triggers when the patching is done"}}},"if_v2_1":{"type":"if_v2","logging_enabled":false,"x":1579,"y":429,"group":"group_5","inputs":{"b":{"export_enabled":true,"data":["new_adset_into_above_campaign","new_adset_from_template"]},"condition":{"export_enabled":true,"data":"in"}},"outputs":{"true":{"title":" new_adset","description":"Triggers when the evaluation is true"},"false":{"title":"existing_adset","description":"Triggers when the evaluation is false"}}},"extract_3":{"type":"extract_v2","logging_enabled":false,"x":882,"y":332,"group":"group_5","inputs":{"pointer":{"export_enabled":true,"data":"/config/action"}},"outputs":{"data":{"title":"action","description":"The extracted data"}}},"input_any_3":{"type":"input_any","logging_enabled":false,"x":230,"y":829,"group":"group_2","inputs":{"any":{"export_enabled":true,"data":"https://business-api.tiktok.com/open_api/v1.3/adgroup/get/?advertiser_id=7153616368384933889\u0026filtering={\"adgroup_ids\":[\"1757089654312962\"]}\n"}}},"if_v2_2":{"type":"if_v2","logging_enabled":false,"x":1229,"y":152,"group":"group_5","inputs":{"b":{"export_enabled":true,"data":"new_campaign_and_adset_from_template"},"condition":{"export_enabled":true,"data":"equal"}},"outputs":{"true":{"title":"  new_campaign","description":"Triggers when the evaluation is true"},"false":{"title":"existing_campaign","description":"Triggers when the evaluation is false"}}},"patch_json_v2_6":{"type":"patch_json_v2","logging_enabled":false,"x":1184,"y":569,"group":"group_4","inputs":{"patches":{"export_enabled":true,"data":[{"op":"move","path":"/creatives/0/adgroup_id","from":"/adgroup_id"},{"op":"move","path":"","from":"/creatives/0"}]},"value":{"export_enabled":true}}},"patch_json_v2_7":{"type":"patch_json_v2","logging_enabled":false,"x":859,"y":373,"group":"group_2","inputs":{"patches":{"export_enabled":true,"data":[{"op":"remove","path":"/adgroup_id"},{"op":"replace","path":"/adgroup_name","value":"{{input.value/config/adgroup_name}}"},{"op":"replace","path":"/operation_status","value":"DISABLE"},{"op":"remove","path":"/create_time"},{"op":"remove","path":"/modify_time"}]}}},"patch_json_v2_8":{"type":"patch_json_v2","logging_enabled":false,"x":1038,"y":214,"group":"group_8","inputs":{"value":{"title":"adgroup_id","description":"A value that can be used in patches"},"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/adgroup_id","value":"{{input.value}}"}]}}},"patch_json_v2_9":{"type":"patch_json_v2","logging_enabled":false,"x":1084,"y":577,"group":"group_8","inputs":{"value":{"title":"","description":"A value that can be used in patches"},"patches":{"export_enabled":true,"data":[]}}},"if_v2_3":{"type":"if_v2","logging_enabled":false,"x":603,"y":291,"group":"group_8","inputs":{"a":{"title":"action","description":"Write or paste the data A"},"b":{"export_enabled":true,"data":"insert_into_existing_adset"},"condition":{"export_enabled":true,"data":"equal"}}},"patch_json_v2_10":{"type":"patch_json_v2","logging_enabled":false,"x":523,"y":286,"group":"group_4","inputs":{"value":{"title":"ad_to_be","description":"A value that can be used in patches"},"data":{"export_enabled":true,"data":{"adgroup_id":"","creatives":[{"ad_name":"","call_to_action":"","ad_format":"SINGLE_VIDEO","ad_text":"","image_ids":[],"video_id":"","landing_page_url":"","identity_id":"","identity_type":"CUSTOMIZED_USER"}]}},"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/adgroup_id","value":"{{input.value/config/adgroup_id}}"},{"op":"replace","path":"/creatives/0/ad_name","value":"{{input.value/ad_creative/ad_name}}"},{"op":"replace","path":"/creatives/0/call_to_action","value":"{{input.value/ad_creative/call_to_action}}"},{"op":"replace","path":"/creatives/0/ad_text","value":"{{input.value/ad_creative/ad_text}}"},{"op":"replace","path":"/creatives/0/video_id","value":"{{input.value/ad_creative/video_id}}"},{"op":"add","path":"/creatives/0/landing_page_url","value":"{{input.value/ad_creative/url}}"},{"op":"replace","path":"/creatives/0/identity_id","value":"{{input.value/ad_creative/identity_id}}"},{"op":"add","path":"/creatives/0/image_ids/0","value":"{{input.value/ad_creative/thumbnail_id}}"}]}}},"converge_2":{"type":"converge","logging_enabled":false,"x":1512,"y":416,"group":"group_8"},"data_relay_4":{"type":"data_relay","logging_enabled":false,"x":302,"y":524,"group":"group_8","inputs":{"data":{"title":"ad_to_be","description":"Data to relay"}}},"if_v2_4":{"type":"if_v2","logging_enabled":false,"x":1135,"y":356,"group":"group_2","inputs":{"condition":{"export_enabled":true,"data":"in"},"b":{"export_enabled":true,"data":["new_campaign_and_adset_from_template","new_adset_into_above_campaign"]},"a":{"title":"action","description":"Write or paste the data A"}}},"patch_json_v2_11":{"type":"patch_json_v2","logging_enabled":false,"x":1436,"y":559,"group":"group_2","inputs":{"patches":{"export_enabled":true,"data":[]},"value":{"export_enabled":true}}},"patch_json_v2_12":{"type":"patch_json_v2","logging_enabled":false,"x":1429,"y":248,"group":"group_2","inputs":{"value":{"title":"campaign_id","description":"A value that can be used in patches"},"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/campaign_id","value":"{{input.value/id}}"}]}}}},"edges":["start_1.start:google_sheets_fetch_table_rows_v3_1.fetch","for_each_v2_1.done:stop_1.stop","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","patch_json_v2_7.data:patch_json_v2_12.data","extract_3.data:if_v2_2.a","extract_3.data:if_v2_1.a","extract_3.extracted:if_v2_2.evaluate","if_v2_2.false:if_v2_1.evaluate","tik_tok_fetch_ad_group_1.fetched:patch_json_v2_7.patch","tik_tok_fetch_ad_group_1.ad_group:patch_json_v2_7.data","tik_tok_create_ad_group_1.created:extract_v2_2.extract","extract_v2_2.data:patch_json_v2_8.value","extract_v2_2.extracted:patch_json_v2_10.patch","patch_json_v2_5.patched:tik_tok_create_ad_group_1.create","tik_tok_create_ad_group_1.ad_group_id:extract_v2_2.data","extract_3.data:if_v2_3.a","if_v2_3.false:patch_json_v2_8.patch","if_v2_3.true:patch_json_v2_9.patch","patch_json_v2_8.data:converge_2.data","patch_json_v2_9.data:converge_2.data","patch_json_v2_9.patched:converge_2.converge","patch_json_v2_8.patched:converge_2.converge","if_v2_1.false:patch_json_v2_10.patch","data_relay_4.data:patch_json_v2_9.data","data_relay_4.data:patch_json_v2_8.data","patch_json_v2_7.patched:if_v2_4.evaluate","extract_3.data:if_v2_4.a","if_v2_4.true:patch_json_v2_12.patch","patch_json_v2_7.data:patch_json_v2_11.data","if_v2_4.false:patch_json_v2_11.patch","patch_json_v2_12.data:converge_1.data","patch_json_v2_12.patched:converge_1.converge","patch_json_v2_11.data:converge_1.data","patch_json_v2_11.patched:converge_1.converge","data_relay_1.data:patch_json_v2_4.value","data_relay_1.data:extract_1.data","data_relay_2.data:patch_json_v2_7.value","data_relay_2.data:extract_2.data","patch_json_v2_4.data:patch_json_v2_3.data","patch_json_v2_4.patched:patch_json_v2_3.patch","converge_1.converged:timestamp_1.now","timestamp_1.timestamp:calculate_math_operation_1.a","timestamp_1.done:calculate_math_operation_1.calculate","calculate_math_operation_1.data:format_timestamp_v2_1.timestamp","calculate_math_operation_1.calculated:format_timestamp_v2_1.format","format_timestamp_v2_1.date_time:patch_json_v2_5.value","format_timestamp_v2_1.formatted:patch_json_v2_5.patch","converge_1.data:patch_json_v2_5.data","converge_2.converged:patch_json_v2_6.patch","patch_json_v2_6.patched:tik_tok_create_ad_1.create","converge_2.data:patch_json_v2_6.data","patch_json_v2_6.data:tik_tok_create_ad_1.data","google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id:google_sheets_update_table_rows_v2_1.spreadsheet_id","parse_string_to_id_2.parsed:tik_tok_fetch_ad_group_1.fetch","parse_string_to_id_1.parsed:tik_tok_fetch_campaign_1.fetch","parse_string_to_id_1.result:tik_tok_fetch_campaign_1.campaign_id","extract_1.data:parse_string_to_id_1.value","patch_json_v2_3.data:tik_tok_create_campaign_1.data","tik_tok_select_ad_account_id_1.ad_account_id:tik_tok_select_ad_account_id_2.ad_account_id","input_any_1.any:parse_string_to_id_1.schema","extract_1.extracted:parse_string_to_id_1.parse","patch_json_v2_3.patched:tik_tok_create_campaign_1.create","tik_tok_fetch_campaign_1.fetched:patch_json_v2_4.patch","tik_tok_create_campaign_1.campaign_id:patch_json_v2_12.value","if_v2_2.true:extract_1.extract","extract_2.data:parse_string_to_id_2.value","parse_string_to_id_2.result:tik_tok_fetch_ad_group_1.ad_group_id","if_v2_1.true:extract_2.extract","tik_tok_select_ad_account_id_4.ad_account_id:tik_tok_create_ad_1.ad_account_id","patch_json_v2_10.patched:if_v2_3.evaluate","tik_tok_select_ad_account_id_2.ad_account_id:tik_tok_fetch_campaign_1.ad_account_id","tik_tok_select_ad_account_id_2.ad_account_id:tik_tok_create_campaign_1.ad_account_id","tik_tok_fetch_campaign_1.campaign:patch_json_v2_4.data","patch_json_v2_5.data:tik_tok_create_ad_group_1.data","tik_tok_select_ad_account_id_3.ad_account_id:tik_tok_create_ad_group_1.ad_account_id","tik_tok_select_ad_account_id_1.ad_account_id:tik_tok_select_ad_account_id_3.ad_account_id","input_any_2.any:parse_string_to_id_2.schema","extract_2.extracted:parse_string_to_id_2.parse","tik_tok_select_ad_account_id_3.ad_account_id:tik_tok_fetch_ad_group_1.ad_account_id","tik_tok_create_campaign_1.created:extract_2.extract","tik_tok_select_ad_account_id_1.ad_account_id:tik_tok_select_ad_account_id_4.ad_account_id","patch_json_v2_10.data:data_relay_4.data","tik_tok_create_ad_1.ad_id:data_relay_3.data","google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id:google_sheets_fetch_table_row_mapping_1.spreadsheet_id","google_sheets_fetch_table_row_mapping_1.mapping:map_table_rows_1.mapping","google_sheets_fetch_table_row_mapping_1.fetched:slice_list_v3_1.slice","slice_list_v3_1.sliced:map_table_rows_1.map","map_table_rows_1.mapped:filter_v2_1.filter","filter_v2_1.items:patch_json_list_v2_1.data_list","filter_v2_1.filtered:patch_json_list_v2_1.patch","for_each_v2_1.item:extract_v2_1.data","extract_v2_1.extracted:extract_3.extract","extract_v2_1.data:data_relay_2.data","extract_v2_1.data:data_relay_1.data","extract_v2_1.data:patch_json_v2_10.value","unmap_table_rows_1.unmapped:google_sheets_update_table_rows_v2_1.update","patch_json_v2_1.data:patch_json_v2_2.value","google_sheets_fetch_table_row_mapping_1.mapping:unmap_table_rows_1.mapping","patch_json_list_v2_1.patched:for_each_v2_1.start","patch_json_list_v2_1.data_list:for_each_v2_1.items","tik_tok_create_ad_1.created:patch_json_v2_1.patch","google_sheets_select_spreadsheet_id_v2_1.range:google_sheets_fetch_table_row_mapping_1.range","google_sheets_fetch_table_rows_v3_1.rows:slice_list_v3_1.data_list","slice_list_v3_1.data_list:map_table_rows_1.rows","map_table_rows_1.mapped_rows:filter_v2_1.items","google_sheets_fetch_table_rows_v3_1.fetched:google_sheets_fetch_table_row_mapping_1.fetch","for_each_v2_1.do:extract_v2_1.extract","extract_v2_1.data:extract_3.data","patch_json_v2_2.data:unmap_table_rows_1.mapped_rows","unmap_table_rows_1.rows:google_sheets_update_table_rows_v2_1.rows","patch_json_v2_2.patched:unmap_table_rows_1.unmap","data_relay_3.data:patch_json_v2_1.value","patch_json_v2_1.patched:patch_json_v2_2.patch","for_each_v2_1.item:patch_json_v2_1.data","google_sheets_update_table_rows_v2_1.updated:for_each_v2_1.next"],"groups":{"group_1":{"title":"Create Campaign","description":"","x":1082,"y":228,"inputs":["data_relay_1.data","tik_tok_select_ad_account_id_2.ad_account_id","extract_1.extract"],"outputs":["tik_tok_create_campaign_1.created","tik_tok_create_campaign_1.campaign_id"]},"group_5":{"title":"Control Flow","description":"","x":752,"y":296,"inputs":["extract_v2_1.data","extract_v2_1.extract"],"outputs":["extract_v2_1.data","if_v2_2.true","extract_3.data","if_v2_1.false","if_v2_1.true"]},"group_4":{"title":"Create Ad","description":"","x":1814,"y":210,"inputs":["patch_json_v2_10.value","patch_json_v2_10.patch","if_v2_3.a","patch_json_v2_8.value","tik_tok_select_ad_account_id_4.ad_account_id"],"outputs":["tik_tok_create_ad_1.ad_id","tik_tok_create_ad_1.created"]},"group_9":{"title":"Create PAC Video Ad","description":"","x":4705,"y":2987},"group_10":{"title":"Create PAC Video Ad","description":"","x":4352,"y":2997},"group_6":{"title":"Update Sheet","description":"","x":2150,"y":463,"inputs":["data_relay_3.data","unmap_table_rows_1.mapping","patch_json_v2_1.patch","patch_json_v2_1.data","google_sheets_update_table_rows_v2_1.spreadsheet_id"],"outputs":["google_sheets_update_table_rows_v2_1.updated"]},"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_8":{"title":"Replace AdGroup Id","description":"","x":921,"y":349,"group":"group_4","inputs":["if_v2_3.evaluate","if_v2_3.a","patch_json_v2_8.value","data_relay_4.data"],"outputs":["converge_2.data","converge_2.converged"]},"group_3":{"title":"Extract Ad Group Id","description":"","x":279,"y":377,"group":"group_2","inputs":["extract_2.data","extract_2.extract"],"outputs":["parse_string_to_id_2.result","parse_string_to_id_2.parsed"]},"group_2":{"title":"Create Ad Group","description":"","x":1517,"y":225,"inputs":["patch_json_v2_12.value","if_v2_4.a","data_relay_2.data","tik_tok_select_ad_account_id_3.ad_account_id","extract_2.extract"],"outputs":["extract_v2_2.data","extract_v2_2.extracted"]}},"widgets":{"widget_1":{"title":"Spreadsheet","description":"The spreadsheet to fetch from","position":2,"input":"google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id"},"widget_2":{"title":"Range / Tab","description":"The range in A1 notation to fetch","position":3,"icon":"las la-table","input":"google_sheets_select_spreadsheet_id_v2_1.range"},"widget_3":{"title":"Ad Account","description":"Select one TikTok Ad Account","position":0,"input":"tik_tok_select_ad_account_id_1.ad_account_id"}},"variables":{},"config":{"capture_inputs_enabled":false,"caching_enabled":false},"tags":[]}

Upload assets from DropboxBusiness

{"name":"Upload Assets (DropboxBusiness -\u003e TikTok)","description":"upload_assets_dropbox_2023028","nodes":{"stop_1":{"type":"stop","logging_enabled":false,"error_rules":[],"x":1371,"y":702},"trigger_relay_1":{"type":"trigger_relay","logging_enabled":false,"error_rules":[],"x":2232,"y":769,"group":"group_1"},"data_relay_1":{"type":"data_relay","title":"Relay URL","description":"Relays data","logging_enabled":false,"error_rules":[],"x":84,"y":809,"group":"group_1","inputs":{"data":{"title":"url","description":"Data to relay"}}},"google_sheets_select_spreadsheet_id_v2_1":{"type":"google_sheets_select_spreadsheet_id_v2","logging_enabled":false,"error_rules":[],"x":638,"y":66,"group":"group_1","inputs":{"range":{"export_enabled":true},"spreadsheet_id":{"export_enabled":true}}},"data_relay_2":{"type":"data_relay","title":"Relay Name","description":"Relays data","logging_enabled":false,"error_rules":[],"x":50,"y":506,"group":"group_1","inputs":{"data":{"title":"name","description":"Data to relay"}}},"extract_1":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":1362,"y":915,"group":"group_2","inputs":{"pointer":{"export_enabled":true,"data":"/data/image_url"}}},"patch_json_v2_1":{"type":"patch_json_v2","logging_enabled":false,"error_rules":[],"x":849,"y":231,"group":"group_3","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/context/asset_name","value":"{{input.value}}"}]}}},"patch_json_v2_2":{"type":"patch_json_v2","logging_enabled":false,"error_rules":[],"x":584,"y":247,"group":"group_3","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/context/image/url","value":"{{input.value}}"}]}}},"map_any_to_table_rows_1":{"type":"map_any_to_table_rows","logging_enabled":false,"error_rules":[],"x":1117,"y":227,"group":"group_3","inputs":{"add_header":{"export_enabled":true,"data":true},"mapping":{"export_enabled":true,"data":{"A":"/context/asset_name","B":"/type","C":"/id","D":"/context/image/url"}},"schema":{"export_enabled":true,"data":"any"}}},"extract_2":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":300,"y":539,"group":"group_4","inputs":{"pointer":{"export_enabled":true,"data":"/video_cover_url"}}},"clone_file_v2_1":{"type":"clone_file_v2","logging_enabled":false,"error_rules":[],"x":681,"y":320,"group":"group_4"},"patch_json_v3_1":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":147,"y":299,"group":"group_5","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/video_cover_url","value":"{{inputValue('')}}"},{"op":"add","path":"/type","value":"ad_video"}]}}},"clone_file_v2_2":{"type":"clone_file_v2","logging_enabled":false,"error_rules":[],"x":1756,"y":758,"group":"group_2"},"post_integration_url_v2_1":{"type":"post_integration_url_v2","logging_enabled":false,"error_rules":[],"x":589,"y":243,"group":"group_6","inputs":{"headers":{"export_enabled":true,"data":{"Dropbox-API-Path-Root":"{\".tag\": \"namespace_id\",\"namespace_id\": \"10251950448\"}","Dropbox-API-Select-User":"dbmid:AABjj6xWfV-HLSOWmubTgjC92XJGTr6RIBI"}},"url":{"export_enabled":true,"data":"https://api.dropboxapi.com/2/files/get_temporary_link"},"provider":{"export_enabled":true,"data":"dropbox_business"}}},"post_integration_url_v2_2":{"type":"post_integration_url_v2","logging_enabled":false,"error_rules":[],"x":964,"y":382,"group":"group_7","inputs":{"headers":{"export_enabled":true,"data":{"Dropbox-API-Path-Root":"{\".tag\": \"namespace_id\",\"namespace_id\": \"10251950448\"}","Dropbox-API-Select-User":"dbmid:AABjj6xWfV-HLSOWmubTgjC92XJGTr6RIBI"}},"url":{"export_enabled":true,"data":"https://api.dropboxapi.com/2/files/list_folder"},"provider":{"export_enabled":true,"data":"dropbox_business"}},"outputs":{"posted":{"title":"posted","description":"Triggered when the request was executed"}}},"google_sheets_append_table_rows_v3_1":{"type":"google_sheets_append_table_rows_v3","logging_enabled":false,"error_rules":[],"x":1877,"y":909,"group":"group_1"},"start_1":{"type":"start","logging_enabled":false,"error_rules":[],"x":38,"y":423},"for_each_v2_1":{"type":"for_each_v2","logging_enabled":false,"error_rules":[],"x":1054,"y":267,"inputs":{"start":{"title":"start","description":"Starts the first iteration"}}},"extract_3":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":928,"y":314,"group":"group_6","inputs":{"pointer":{"export_enabled":true,"data":"/link"}},"outputs":{"data":{"title":"temp_file_link","description":"The extracted data"}}},"extract_4":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":1277,"y":323,"group":"group_6","inputs":{"pointer":{"export_enabled":true,"data":"/metadata/name"}},"outputs":{"extracted":{"title":"extracted","description":"Triggers when the data was extracted"},"data":{"title":"file_name","description":"The extracted data"}}},"patch_json_v2_3":{"type":"patch_json_v2","logging_enabled":false,"error_rules":[],"x":151,"y":162,"group":"group_6","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/path","value":"{{input.value/path_lower}}"}]},"data":{"export_enabled":true,"data":{"path":""}}}},"google_sheets_fetch_table_rows_v3_1":{"type":"google_sheets_fetch_table_rows_v3","logging_enabled":false,"error_rules":[],"x":509,"y":284,"group":"group_8","inputs":{"date_time_render_option":{"export_enabled":true,"data":"FORMATTED_STRING"},"value_render_option":{"export_enabled":true,"data":"UNFORMATTED_VALUE"},"dimension":{"export_enabled":true,"data":"ROWS"}}},"extract_list_1":{"type":"extract_list","logging_enabled":false,"error_rules":[],"x":780,"y":406,"group":"group_8","inputs":{"pointer":{"export_enabled":true,"data":"/columns/0"}},"outputs":{"extracted":{"title":"extracted","description":"Triggers when the data was extracted"},"data_list":{"title":"existing_assets","description":"The extracted data"}}},"filter_v2_1":{"type":"filter_v2","logging_enabled":false,"error_rules":[],"x":309,"y":313,"group":"group_9","inputs":{"filters":{"export_enabled":true,"data":[{"value":"(.mp4|.m4v|.mov|.gif|.jpg|.jpeg|.png)","pointer":"/name","operator":"matches"}]}},"outputs":{"filtered":{"title":"filtered","description":"Triggered when filtered"}}},"google_sheets_append_table_rows_v3_2":{"type":"google_sheets_append_table_rows_v3","logging_enabled":false,"error_rules":[],"x":1916,"y":419,"group":"group_1"},"extract_5":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":1259,"y":489,"group":"group_7","inputs":{"pointer":{"export_enabled":true,"data":"/entries"}},"outputs":{"extracted":{"title":"extracted","description":"Triggers when the data was extracted"}}},"extract_6":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":2144,"y":423,"group":"group_7","inputs":{"pointer":{"export_enabled":true,"data":"/entries"}},"outputs":{"extracted":{"title":"extracted","description":"Triggers when the data was extracted"}}},"patch_json_v2_4":{"type":"patch_json_v2","logging_enabled":false,"error_rules":[],"x":1531,"y":340,"group":"group_7","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/cursor","value":"{{input.value/cursor}}"}]},"data":{"export_enabled":true,"data":{"cursor":""}}}},"post_integration_url_v2_3":{"type":"post_integration_url_v2","logging_enabled":false,"error_rules":[],"x":1844,"y":299,"group":"group_7","inputs":{"headers":{"export_enabled":true,"data":{"Dropbox-API-Path-Root":"{\".tag\": \"namespace_id\",\"namespace_id\": \"10251950448\"}","Dropbox-API-Select-User":"dbmid:AABjj6xWfV-HLSOWmubTgjC92XJGTr6RIBI"}},"url":{"export_enabled":true,"data":"https://api.dropboxapi.com/2/files/list_folder/continue"},"provider":{"export_enabled":true,"data":"dropbox_business"}}},"concat_1":{"type":"concat","logging_enabled":false,"error_rules":[],"x":2463,"y":600,"group":"group_7","inputs":{"schema":{"export_enabled":true,"data":"any"}}},"patch_json_v2_5":{"type":"patch_json_v2","logging_enabled":false,"error_rules":[],"x":644,"y":357,"group":"group_7","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/recursive","value":"{{input.value}}"}]},"data":{"title":"body","description":"The data the patches are applied to"}}},"patch_json_v2_6":{"type":"patch_json_v2","logging_enabled":false,"error_rules":[],"x":320,"y":258,"group":"group_7","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/path","value":"{{input.value}}"}]},"data":{"title":"body","description":"The data the patches are applied to","export_enabled":true,"data":{"path":"","recursive":false,"limit":2000}}}},"input_string_1":{"type":"input_string","title":"Path","description":"Allows to input a string","logging_enabled":false,"max_job_retries":6,"timeout":30,"error_rules":[],"x":61,"y":259,"group":"group_7","inputs":{"string":{"title":"path","description":"A string to input","export_enabled":true}}},"input_boolean_1":{"type":"input_boolean","logging_enabled":false,"error_rules":[],"x":362,"y":649,"group":"group_7","inputs":{"boolean":{"export_enabled":true,"data":true}}},"filter_v2_2":{"type":"filter_v2","logging_enabled":false,"error_rules":[],"x":2749,"y":655,"group":"group_7","inputs":{"filters":{"export_enabled":true,"data":[{"operator":"=","pointer":"/is_downloadable","value":true}]}},"outputs":{"filtered":{"title":"filtered","description":"Triggered when the list was filtered"}}},"if_v2_1":{"type":"if_v2","logging_enabled":false,"error_rules":[],"x":1018,"y":514,"group":"group_10","inputs":{"condition":{"export_enabled":true,"data":"in"},"a":{"export_enabled":true,"data":".png"}},"outputs":{"false":{"title":"is_video","description":"Triggers when the evaluation is false"}}},"data_relay_3":{"type":"data_relay","logging_enabled":false,"error_rules":[],"x":292,"y":572,"group":"group_10","inputs":{"data":{"title":"name","description":"Data to relay"}}},"extract_list_2":{"type":"extract_list","logging_enabled":false,"error_rules":[],"x":638,"y":516,"group":"group_9","inputs":{"pointer":{"export_enabled":true,"data":"/name"}}},"if_v2_2":{"type":"if_v2","logging_enabled":false,"error_rules":[],"x":667,"y":317,"group":"group_10","inputs":{"condition":{"export_enabled":true,"data":"in"},"a":{"export_enabled":true,"data":".jp"}}},"trigger_relay_2":{"type":"trigger_relay","logging_enabled":false,"error_rules":[],"x":1408,"y":567,"group":"group_10","outputs":{"relayed":{"title":"is_image","description":"Output trigger from relay"}}},"filter_v2_3":{"type":"filter_v2","logging_enabled":false,"error_rules":[],"x":1867,"y":627,"group":"group_9","inputs":{"filters":{"export_enabled":true,"data":[{"operator":"!=","pointer":"/check","value":null}]}},"outputs":{"filtered":{"title":"filtered","description":"Triggered when the list was filtered"}}},"join_data_1":{"type":"join_data","logging_enabled":false,"error_rules":[],"x":1556,"y":473,"group":"group_9","inputs":{"conditions":{"title":"conditions","description":"Conditions the lists get joined by","export_enabled":true,"data":[{"a":"/name","b":"/name"}]},"target":{"export_enabled":true,"data":"/check"}}},"calculate_set_operation_1":{"type":"calculate_set_operation","logging_enabled":false,"error_rules":[],"x":952,"y":665,"group":"group_9","inputs":{"operator":{"export_enabled":true,"data":"-"},"b":{"title":"b: existing_assets","description":"Set B"}}},"patch_json_list_v2_1":{"type":"patch_json_list_v2","logging_enabled":false,"error_rules":[],"x":1492,"y":709,"group":"group_11","inputs":{"patches":{"export_enabled":true,"data":[{"op":"move","path":"/name","from":"/id"},{"op":"remove","path":"/provider"},{"op":"remove","path":"/type"}]},"value":{"export_enabled":true}}},"parse_strings_to_ids_1":{"type":"parse_strings_to_ids","logging_enabled":false,"error_rules":[],"x":1224,"y":729,"group":"group_11","inputs":{"schema":{"export_enabled":true,"data":"snapchat_ad_account_id"}}},"post_integration_url_v2_4":{"type":"post_integration_url_v2","title":"Get current account","description":"Posts to a json url endpoint of an integration provider and returns a sucessful json body","logging_enabled":false,"max_job_retries":1,"timeout":180,"error_rules":[],"x":643,"y":644,"group":"group_7","inputs":{"headers":{"export_enabled":true},"body":{"export_enabled":true},"url":{"export_enabled":true,"data":"https://api.dropboxapi.com/2/users/get_current_account"},"provider":{"export_enabled":true,"data":"dropbox"}}},"patch_json_v3_2":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":466,"y":309,"group":"group_5","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/file_name","value":"{{inputValue('')}}"},{"op":"add","path":"/timestamp","value":"{{formatTime(timeNow(\"UTC\"), \"%Y-%m-%dT%H:%M:%S%z\")}}"}]}}},"tik_tok_select_ad_account_id_1":{"type":"tik_tok_select_ad_account_id","logging_enabled":false,"error_rules":[],"x":205,"y":144,"group":"group_1","inputs":{"ad_account_id":{"export_enabled":true}}},"patch_json_v3_3":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":510,"y":762,"group":"group_12","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/advertiser_id","value":"{{inputValue(\"/id\")}}"}]},"value":{"title":"ad_account_id","description":"Input any value that can be used in patches"},"data":{"export_enabled":true,"data":{"advertiser_id":"7211073649556668418","upload_type":"UPLOAD_BY_URL","image_url":"","file_name":""}}}},"patch_json_v3_4":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":750,"y":754,"group":"group_12","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/image_url","value":"{{inputValue(\"\")}}"}]},"value":{"title":"url","description":"Input any value that can be used in patches"}}},"post_integration_url_v2_5":{"type":"post_integration_url_v2","logging_enabled":false,"error_rules":[],"x":1274,"y":762,"group":"group_12","inputs":{"headers":{"export_enabled":true},"url":{"export_enabled":true,"data":"https://business-api.tiktok.com/open_api/v1.3/file/image/ad/upload/"},"provider":{"export_enabled":true,"data":"tik_tok"}}},"patch_json_v3_5":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1019,"y":756,"group":"group_12","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/file_name","value":"{{inputValue(\"\")}}"}]},"value":{"title":"file_name","description":"Input any value that can be used in patches"}}},"patch_json_v3_6":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":335,"y":252,"group":"group_3","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/id","value":"{{inputValue(\"/data/image_id\")}}"},{"op":"add","path":"/type","value":"ad_image"}]},"data":{"export_enabled":true,"data":{}}}},"tik_tok_fetch_ad_videos_v2_1":{"type":"tik_tok_fetch_ad_videos_v2","logging_enabled":false,"error_rules":[],"x":1385,"y":513,"group":"group_13","outputs":{"fetched":{"title":"fetched","description":"Triggered when the ad videos were fetched"}}},"concat_2":{"type":"concat","logging_enabled":false,"error_rules":[],"x":794,"y":487,"group":"group_13","inputs":{"b":{"export_enabled":true},"schema":{"export_enabled":true,"data":"any"}}},"tik_tok_upload_ad_video_1":{"type":"tik_tok_upload_ad_video","logging_enabled":false,"error_rules":[],"x":509,"y":484,"group":"group_13"},"tik_tok_select_ad_account_id_2":{"type":"tik_tok_select_ad_account_id","logging_enabled":false,"error_rules":[],"x":251,"y":478,"group":"group_13"},"extract_v2_1":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":1671,"y":548,"group":"group_13","inputs":{"default_value":{"export_enabled":true},"pointer":{"export_enabled":true,"data":"/0"}}},"map_any_to_table_rows_2":{"type":"map_any_to_table_rows","logging_enabled":false,"error_rules":[],"x":747,"y":299,"group":"group_5","inputs":{"add_header":{"export_enabled":true,"data":true},"mapping":{"export_enabled":true,"data":{"A":"/file_name","B":"/type","C":"/video_id","D":"/video_cover_url","E":"/timestamp"}},"schema":{"export_enabled":true,"data":"any"}}},"delay_1":{"type":"delay","logging_enabled":false,"error_rules":[],"x":1103,"y":520,"group":"group_13","inputs":{"duration":{"export_enabled":true,"data":30}}}},"edges":[{"id":"post_integration_url_v2_2.body:extract_5.data","points":[]},{"id":"patch_json_v2_4.patched:post_integration_url_v2_3.post","points":[]},{"id":"post_integration_url_v2_3.body:extract_6.data","points":[]},{"id":"post_integration_url_v2_2.posted:extract_5.extract","points":[]},{"id":"post_integration_url_v2_2.body:patch_json_v2_4.value","points":[]},{"id":"post_integration_url_v2_3.posted:extract_6.extract","points":[]},{"id":"patch_json_v2_4.data:post_integration_url_v2_3.body","points":[]},{"id":"extract_6.extracted:concat_1.concat","points":[]},{"id":"extract_6.data:concat_1.a","points":[]},{"id":"extract_5.data:concat_1.b","points":[]},{"id":"extract_5.extracted:patch_json_v2_4.patch","points":[]},{"id":"for_each_v2_1.done:stop_1.stop","points":[]},{"id":"post_integration_url_v2_1.posted:extract_3.extract","points":[]},{"id":"patch_json_v2_3.patched:post_integration_url_v2_1.post","points":[]},{"id":"extract_2.data:clone_file_v2_1.url","points":[]},{"id":"extract_2.extracted:clone_file_v2_1.clone","points":[]},{"id":"extract_1.data:clone_file_v2_2.url","points":[]},{"id":"extract_1.extracted:clone_file_v2_2.clone","points":[]},{"id":"clone_file_v2_1.cloned:patch_json_v3_1.patch","points":[]},{"id":"patch_json_v3_1.data:patch_json_v3_2.data","points":[]},{"id":"patch_json_v3_1.patched:patch_json_v3_2.patch","points":[]},{"id":"map_any_to_table_rows_2.rows:google_sheets_append_table_rows_v3_2.rows","points":[]},{"id":"map_any_to_table_rows_2.mapped:google_sheets_append_table_rows_v3_2.append","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id:google_sheets_append_table_rows_v3_2.spreadsheet_id","points":[]},{"id":"google_sheets_append_table_rows_v3_2.appended:trigger_relay_1.relay","points":[]},{"id":"patch_json_v2_2.data:patch_json_v2_1.data","points":[]},{"id":"patch_json_v2_2.patched:patch_json_v2_1.patch","points":[]},{"id":"patch_json_v2_1.data:map_any_to_table_rows_1.data","points":[]},{"id":"patch_json_v2_1.patched:map_any_to_table_rows_1.map","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_append_table_rows_v3_1.append","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id:google_sheets_append_table_rows_v3_1.spreadsheet_id","points":[]},{"id":"google_sheets_append_table_rows_v3_1.appended:trigger_relay_1.relay","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_1.range:google_sheets_append_table_rows_v3_2.range","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_1.range:google_sheets_append_table_rows_v3_1.range","points":[]},{"id":"filter_v2_3.filtered:for_each_v2_1.start","points":[]},{"id":"patch_json_v3_4.patched:patch_json_v3_5.patch","points":[]},{"id":"patch_json_v3_4.data:patch_json_v3_5.data","points":[]},{"id":"patch_json_v3_5.data:post_integration_url_v2_5.body","points":[]},{"id":"post_integration_url_v2_1.body:extract_4.data","points":[]},{"id":"trigger_relay_1.relayed:for_each_v2_1.next","points":[]},{"id":"patch_json_v2_3.data:post_integration_url_v2_1.body","points":[]},{"id":"post_integration_url_v2_1.body:extract_3.data","points":[]},{"id":"extract_3.extracted:extract_4.extract","points":[]},{"id":"input_string_1.string:patch_json_v2_6.value","points":[]},{"id":"for_each_v2_1.item:patch_json_v2_3.value","points":[]},{"id":"google_sheets_fetch_table_rows_v3_1.rows:extract_list_1.data_list","points":[]},{"id":"google_sheets_fetch_table_rows_v3_1.fetched:extract_list_1.extract","points":[]},{"id":"start_1.start:google_sheets_fetch_table_rows_v3_1.fetch","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_1.range:google_sheets_fetch_table_rows_v3_1.range","points":[]},{"id":"extract_list_1.extracted:patch_json_v2_6.patch","points":[]},{"id":"for_each_v2_1.do:patch_json_v2_3.patch","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id:google_sheets_fetch_table_rows_v3_1.spreadsheet_id","points":[]},{"id":"patch_json_v2_6.patched:patch_json_v2_5.patch","points":[]},{"id":"patch_json_v2_5.patched:post_integration_url_v2_2.post","points":[]},{"id":"patch_json_v2_6.data:patch_json_v2_5.data","points":[]},{"id":"input_boolean_1.boolean:patch_json_v2_5.value","points":[]},{"id":"concat_1.list:filter_v2_2.items","points":[]},{"id":"if_v2_2.false:if_v2_1.evaluate","points":[]},{"id":"data_relay_3.data:if_v2_2.b","points":[]},{"id":"if_v2_2.true:trigger_relay_2.relay","points":[]},{"id":"data_relay_2.data:data_relay_3.data","points":[]},{"id":"concat_1.done:filter_v2_2.filter","points":[]},{"id":"filter_v2_2.filtered:filter_v2_1.filter","points":[]},{"id":"filter_v2_2.items:filter_v2_1.items","points":[]},{"id":"data_relay_3.data:if_v2_1.b","points":[]},{"id":"if_v2_1.true:trigger_relay_2.relay","points":[]},{"id":"extract_4.extracted:if_v2_2.evaluate","points":[]},{"id":"filter_v2_1.items:extract_list_2.data_list","points":[]},{"id":"filter_v2_1.filtered:extract_list_2.extract","points":[]},{"id":"extract_list_2.data_list:calculate_set_operation_1.a","points":[]},{"id":"calculate_set_operation_1.data:parse_strings_to_ids_1.values","points":[]},{"id":"calculate_set_operation_1.calculated:parse_strings_to_ids_1.parse","points":[]},{"id":"parse_strings_to_ids_1.parsed:patch_json_list_v2_1.patch","points":[]},{"id":"join_data_1.items:filter_v2_3.items","points":[]},{"id":"extract_list_1.data_list:calculate_set_operation_1.b","points":[]},{"id":"extract_list_2.extracted:calculate_set_operation_1.calculate","points":[]},{"id":"filter_v2_1.items:join_data_1.a","points":[]},{"id":"parse_strings_to_ids_1.result:patch_json_list_v2_1.data_list","points":[]},{"id":"patch_json_list_v2_1.data_list:join_data_1.b","points":[]},{"id":"patch_json_list_v2_1.patched:join_data_1.join","points":[]},{"id":"join_data_1.joined:filter_v2_3.filter","points":[]},{"id":"data_relay_2.data:patch_json_v3_2.value","points":[]},{"id":"data_relay_2.data:patch_json_v2_1.value","points":[]},{"id":"patch_json_v2_5.data:post_integration_url_v2_2.body","points":[]},{"id":"filter_v2_3.items:for_each_v2_1.items","points":[]},{"id":"tik_tok_select_ad_account_id_1.ad_account_id:patch_json_v3_3.value","points":[]},{"id":"patch_json_v3_3.data:patch_json_v3_4.data","points":[]},{"id":"patch_json_v3_3.patched:patch_json_v3_4.patch","points":[]},{"id":"data_relay_1.data:patch_json_v3_4.value","points":[]},{"id":"post_integration_url_v2_5.body:extract_1.data","points":[]},{"id":"post_integration_url_v2_5.posted:extract_1.extract","points":[]},{"id":"trigger_relay_2.relayed:patch_json_v3_3.patch","points":[]},{"id":"data_relay_2.data:patch_json_v3_5.value","points":[]},{"id":"patch_json_v3_5.patched:post_integration_url_v2_5.post","points":[]},{"id":"patch_json_v3_6.data:patch_json_v2_2.data","points":[]},{"id":"patch_json_v3_6.patched:patch_json_v2_2.patch","points":[]},{"id":"clone_file_v2_2.cloned:patch_json_v3_6.patch","points":[]},{"id":"clone_file_v2_1.url:patch_json_v3_1.value","points":[]},{"id":"clone_file_v2_2.url:patch_json_v2_2.value","points":[]},{"id":"post_integration_url_v2_5.body:patch_json_v3_6.value","points":[]},{"id":"extract_4.data:data_relay_2.data","points":[]},{"id":"extract_3.data:data_relay_1.data","points":[]},{"id":"tik_tok_upload_ad_video_1.ad_video_id:concat_2.a","points":[]},{"id":"concat_2.list:tik_tok_fetch_ad_videos_v2_1.ad_video_ids","points":[]},{"id":"tik_tok_upload_ad_video_1.uploaded:concat_2.concat","points":[]},{"id":"tik_tok_select_ad_account_id_2.ad_account_id:tik_tok_upload_ad_video_1.ad_account_id","points":[]},{"id":"tik_tok_select_ad_account_id_2.ad_account_id:tik_tok_fetch_ad_videos_v2_1.ad_account_id","points":[]},{"id":"tik_tok_select_ad_account_id_1.ad_account_id:tik_tok_select_ad_account_id_2.ad_account_id","points":[]},{"id":"data_relay_2.data:tik_tok_upload_ad_video_1.file_name","points":[]},{"id":"data_relay_1.data:tik_tok_upload_ad_video_1.url","points":[]},{"id":"if_v2_1.false:tik_tok_upload_ad_video_1.upload","points":[]},{"id":"tik_tok_fetch_ad_videos_v2_1.ad_videos:extract_v2_1.data","points":[]},{"id":"tik_tok_fetch_ad_videos_v2_1.fetched:extract_v2_1.extract","points":[]},{"id":"extract_v2_1.data:extract_2.data","points":[]},{"id":"extract_v2_1.data:patch_json_v3_1.data","points":[]},{"id":"extract_v2_1.extracted:extract_2.extract","points":[]},{"id":"patch_json_v3_2.data:map_any_to_table_rows_2.data","points":[]},{"id":"patch_json_v3_2.patched:map_any_to_table_rows_2.map","points":[]},{"id":"concat_2.done:delay_1.start","points":[]},{"id":"delay_1.delayed:tik_tok_fetch_ad_videos_v2_1.fetch","points":[]}],"groups":{"group_1":{"title":"Upload and add to Sheet","description":"","x":1737,"y":288,"inputs":["data_relay_1.data","data_relay_2.data","if_v2_2.evaluate"],"outputs":["trigger_relay_1.relayed","google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id","google_sheets_select_spreadsheet_id_v2_1.range"]},"group_2":{"title":"Clone to S3","description":"","x":1145,"y":905,"group":"group_1","inputs":["extract_1.extract","extract_1.data"],"outputs":["clone_file_v2_2.cloned","clone_file_v2_2.url"]},"group_7":{"title":"Dropbox API Request","description":"","x":401,"y":240,"inputs":["patch_json_v2_6.patch","input_string_1.string"],"outputs":["filter_v2_2.items","filter_v2_2.filtered"]},"group_3":{"title":"Map Rows","description":"","x":1483,"y":897,"group":"group_1","inputs":["patch_json_v2_1.value","patch_json_v2_2.value","patch_json_v3_6.patch","patch_json_v3_6.value"],"outputs":["map_any_to_table_rows_1.mapped","map_any_to_table_rows_1.rows"]},"group_4":{"title":"Clone to S3","description":"","x":1098,"y":435,"group":"group_1","inputs":["extract_2.data","extract_2.extract"],"outputs":["clone_file_v2_1.url","clone_file_v2_1.cloned"]},"group_6":{"title":"Get Temporary Link","description":"","x":1384,"y":293,"inputs":["patch_json_v2_3.value","patch_json_v2_3.patch"],"outputs":["extract_3.data","extract_4.extracted","extract_4.data"]},"group_8":{"title":"Get existing assets","description":"","x":122,"y":537,"inputs":["google_sheets_fetch_table_rows_v3_1.range","google_sheets_fetch_table_rows_v3_1.spreadsheet_id","google_sheets_fetch_table_rows_v3_1.fetch"],"outputs":["extract_list_1.data_list","extract_list_1.extracted"]},"group_9":{"title":"Skip uploaded items","description":"","x":723,"y":338,"inputs":["filter_v2_1.items","filter_v2_1.filter","calculate_set_operation_1.b"],"outputs":["filter_v2_3.items","filter_v2_3.filtered"]},"group_5":{"title":"Map Rows","description":"","x":1473,"y":425,"group":"group_1","inputs":["patch_json_v3_2.value","patch_json_v3_1.data","patch_json_v3_1.value","patch_json_v3_1.patch"],"outputs":["map_any_to_table_rows_2.rows","map_any_to_table_rows_2.mapped"]},"group_10":{"title":"Determine Ad Format","description":"","x":388,"y":515,"group":"group_1","inputs":["if_v2_2.evaluate","data_relay_3.data"],"outputs":["if_v2_1.false","trigger_relay_2.relayed"]},"group_11":{"title":"Modify data","description":"","x":1217,"y":717,"group":"group_9","inputs":["parse_strings_to_ids_1.values","parse_strings_to_ids_1.parse"],"outputs":["patch_json_list_v2_1.data_list","patch_json_list_v2_1.patched"]},"group_12":{"title":"Upload TikTok Ad Image","description":"","x":820,"y":906,"group":"group_1","inputs":["patch_json_v3_3.value","patch_json_v3_3.patch","patch_json_v3_4.value","patch_json_v3_5.value"],"outputs":["post_integration_url_v2_5.posted","post_integration_url_v2_5.body"]},"group_13":{"title":"Upload TikTok Ad Video","description":"","x":802,"y":432,"group":"group_1","inputs":["tik_tok_select_ad_account_id_2.ad_account_id","tik_tok_upload_ad_video_1.upload","tik_tok_upload_ad_video_1.url","tik_tok_upload_ad_video_1.file_name"],"outputs":["extract_v2_1.data","extract_v2_1.extracted"]}},"widgets":{"widget_1":{"title":"Include Subfolders?","description":"Should subfolders be included or just files on the path specified above?","position":3,"icon":"las la-folder-open","options":[{"data":true,"title":"TRUE"},{"data":false,"title":"FALSE"}],"input":"input_boolean_1.boolean"},"widget_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":"Tab / Range","description":"The range in A1 notation.","position":7,"icon":"las la-table","input":"google_sheets_select_spreadsheet_id_v2_1.range"},"widget_4":{"title":"Dropbox Folder Path","description":"Add the path to your Dropbox folder starting with a forward slack (/).\nIf an asset with the same name already exists in the spreadsheet, it will be ignored.","position":2,"icon":"lab la-dropbox","input":"input_string_1.string"},"widget_5":{"title":"Ad Account","description":"Select or enter the ad account id","position":0,"input":"tik_tok_select_ad_account_id_1.ad_account_id"}},"variables":{},"config":{"capture_inputs_enabled":false,"caching_enabled":false},"tags":[]}

Upload videos from GDrive

{"name":"Upload videos (GDrive -\u003e TikTok) ","description":"tiktok_upload_assets_gdrive_20230316","nodes":{"replace_string_1":{"type":"replace_string","logging_enabled":false,"error_rules":[],"x":1140,"y":205,"group":"group_1","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,"data":"any"}},"outputs":{"data":{"title":"name","description":"Data that has been partially replaced"}}},"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,"error_rules":[],"x":1143,"y":38,"group":"group_1","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"}}},"google_sheets_fetch_table_rows_v3_1":{"type":"google_sheets_fetch_table_rows_v3","logging_enabled":false,"error_rules":[],"x":509,"y":283,"group":"group_2","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"},"range":{"export_enabled":true},"spreadsheet_id":{"export_enabled":true},"fetch":{"export_enabled":true}}},"extract_list_1":{"type":"extract_list","logging_enabled":false,"error_rules":[],"x":780,"y":406,"group":"group_2","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"}}},"if_v2_1":{"type":"if_v2","logging_enabled":false,"error_rules":[],"x":501,"y":342,"group":"group_1","inputs":{"condition":{"export_enabled":true,"data":"equal"},"a":{"export_enabled":true,"data":"skip"},"evaluate":{"export_enabled":true}}},"input_string_1":{"type":"input_string","logging_enabled":false,"error_rules":[],"x":136,"y":573,"group":"group_1","inputs":{"string":{"title":"skip?","description":"A string to input","export_enabled":true,"data":"skip"}}},"if_v2_2":{"type":"if_v2","logging_enabled":false,"error_rules":[],"x":1441,"y":232,"group":"group_1","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"}}},"trigger_relay_1":{"type":"trigger_relay","logging_enabled":false,"error_rules":[],"x":1873,"y":560,"group":"group_1","outputs":{"relayed":{"title":"upload","description":"Output trigger from relay"}}},"extract_1":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":817,"y":217,"group":"group_1","inputs":{"pointer":{"export_enabled":true,"data":"/name"},"data":{"export_enabled":true}}},"google_sheets_append_table_rows_v3_1":{"type":"google_sheets_append_table_rows_v3","logging_enabled":false,"error_rules":[],"x":1745,"y":219,"group":"group_3","inputs":{"append":{"title":"append","description":"Starts the append"}}},"tik_tok_select_ad_account_id_1":{"type":"tik_tok_select_ad_account_id","logging_enabled":false,"error_rules":[],"x":1154,"y":84,"inputs":{"ad_account_id":{"title":"ad_account_id","description":"Select one TikTok Ad Account"}}},"for_each_v2_1":{"type":"for_each_v2","logging_enabled":false,"error_rules":[],"x":1103,"y":373,"inputs":{"next":{"title":"next","description":"Starts the next iteration"},"start":{"title":" start","description":"Starts the first iteration"}}},"extract_2":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":927,"y":271,"group":"group_4","inputs":{"pointer":{"export_enabled":true,"data":"/id"}}},"google_drive_download_file_1":{"type":"google_drive_download_file","logging_enabled":false,"error_rules":[{"error_type":".*","expression":".*"}],"x":1552,"y":279,"group":"group_4"},"parse_string_to_id_1":{"type":"parse_string_to_id","logging_enabled":false,"error_rules":[],"x":1227,"y":277,"group":"group_4","inputs":{"schema":{"export_enabled":true,"data":"google_drive_folder_id"}}},"extract_3":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":934,"y":243,"group":"group_5","inputs":{"pointer":{"export_enabled":true,"data":"/0/tiktok"}}},"stop_1":{"type":"stop","logging_enabled":false,"error_rules":[],"x":1355,"y":732},"data_relay_1":{"type":"data_relay","logging_enabled":false,"error_rules":[],"x":900,"y":456,"group":"group_6","inputs":{"data":{"title":"file","description":"Data to relay"}}},"data_relay_2":{"type":"data_relay","logging_enabled":false,"error_rules":[],"x":853,"y":139,"group":"group_6","inputs":{"data":{"title":"advertiser_id","description":"Data to relay"}}},"start_1":{"type":"start","logging_enabled":false,"error_rules":[],"x":161,"y":241},"google_drive_fetch_files_v2_1":{"type":"google_drive_fetch_files_v2","logging_enabled":false,"error_rules":[],"x":360,"y":271,"inputs":{"filters":{"export_enabled":true,"data":[]},"include_sub_folders":{"export_enabled":true,"data":true},"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","application/vnd.google-apps.folder"]},"parent_folder_id":{"title":"parent_folder_id","description":"Select a folder where all the files you want to fetch are"}}},"delete_file_1":{"type":"delete_file","title":"Delete Temp File ","description":"Deletes a file (as an URL) from Kitchn.io servers (Amazon S3). Attention: The file can only be deleted when created in this automation.","logging_enabled":false,"max_job_retries":6,"timeout":30,"error_rules":[],"x":2431,"y":187,"group":"group_6"},"tik_tok_upload_ad_video_1":{"type":"tik_tok_upload_ad_video","logging_enabled":false,"error_rules":[{"error_type":".*","expression":".*"}],"x":1280,"y":231,"group":"group_7"},"patch_json_v3_1":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1574,"y":231,"group":"group_7","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/0/group","value":"{{inputValue('')}}"},{"op":"add","path":"/0/root","value":[]},{"op":"move","from":"/0/group","path":"/0/root/0"},{"op":"move","from":"/0/root","path":"/0/tiktok"}]}}},"patch_json_list_v3_1":{"type":"patch_json_list_v3","logging_enabled":false,"error_rules":[],"x":1471,"y":217,"group":"group_6","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/id","value":"{{inputValue(\"/id\")}}"},{"op":"add","path":"/name","value":"{{inputValue(\"/name\")}}"},{"op":"add","path":"/file_extension","value":"{{inputValue(\"/name\")}}"},{"op":"add","path":"/url_thumbnail","value":""}]},"data_list":{"export_enabled":true,"data":[{}]}}},"patch_json_list_v3_2":{"type":"patch_json_list_v3","logging_enabled":false,"error_rules":[],"x":1795,"y":218,"group":"group_6","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/public_url","value":"{{inputValue(\"\")}}"}]}}},"map_any_to_table_rows_1":{"type":"map_any_to_table_rows","logging_enabled":false,"error_rules":[],"x":1440,"y":198,"group":"group_3","inputs":{"add_header":{"export_enabled":true},"schema":{"export_enabled":true,"data":"any_list"}}},"extract_v2_1":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":999,"y":273,"group":"group_7","inputs":{"default_value":{"export_enabled":true},"pointer":{"export_enabled":true,"data":"/0/name"},"extract":{"title":"extract","description":"Starts the extraction"}},"outputs":{"data":{"title":"Name","description":"The extracted data"}}},"join_data_1":{"type":"join_data","logging_enabled":false,"error_rules":[],"x":1855,"y":240,"group":"group_5","inputs":{"conditions":{"export_enabled":true,"data":[{"a":"/tiktok/0/id","b":"/video_id"}]},"target":{"export_enabled":true,"data":""},"b":{"title":"videos","description":"List b that gets joined into the target path"},"a":{"title":"creatives","description":"List a as a baseline"},"join":{"title":"join","description":"Triggers the joining"}},"outputs":{"joined":{"title":"joined","description":"Triggered when joined"}}},"tik_tok_fetch_ad_videos_v2_1":{"type":"tik_tok_fetch_ad_videos_v2","logging_enabled":false,"error_rules":[],"x":1594,"y":229,"group":"group_5"},"data_relay_3":{"type":"data_relay","logging_enabled":false,"error_rules":[],"x":203,"y":198,"group":"group_3"},"replace_list_string_1":{"type":"replace_list_string","logging_enabled":false,"error_rules":[],"x":830,"y":738,"group":"group_3","inputs":{"value":{"export_enabled":true,"data":""},"regex":{"export_enabled":true,"data":"http://p16-sign-sg.tiktokcdn.com/"},"pointer":{"export_enabled":true,"data":"/thumbnail_id"},"schema":{"export_enabled":true,"data":"any"},"data_list":{"export_enabled":true},"replace":{"export_enabled":true}}},"patch_json_list_v3_3":{"type":"patch_json_list_v3","logging_enabled":false,"error_rules":[],"x":1084,"y":194,"group":"group_3","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/url_thumbnail","value":"{{inputValue(\"\")}}"}]},"patch":{"title":"patch","description":"Starts the patching"}}},"replace_list_string_2":{"type":"replace_list_string","logging_enabled":false,"error_rules":[],"x":1098,"y":737,"group":"group_3","inputs":{"value":{"export_enabled":true,"data":""},"regex":{"export_enabled":true,"data":"~.*"},"pointer":{"export_enabled":true,"data":"/thumbnail_id"},"schema":{"export_enabled":true,"data":"any"}}},"input_any_2":{"type":"input_any","logging_enabled":false,"error_rules":[],"x":1109,"y":553,"group":"group_3","inputs":{"any":{"export_enabled":true,"data":{"A":"/name","B":"/format","C":"/video_id","D":"/thumbnail_id","E":"/url_thumbnail"}}}},"extract_v2_2":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":478,"y":211,"group":"group_3","inputs":{"default_value":{"export_enabled":true},"pointer":{"export_enabled":true,"data":"/0/video_cover_url"}}},"clone_file_v2_1":{"type":"clone_file_v2","logging_enabled":false,"error_rules":[],"x":802,"y":224,"group":"group_3"},"fetch_integration_url_v2_1":{"type":"fetch_integration_url_v2","title":"Fetch Integration Url: Suggest Video Cover","description":"Fetches a url with integration credentials and returns a sucessful json body","logging_enabled":false,"max_job_retries":6,"timeout":30,"error_rules":[],"x":2795,"y":341,"group":"group_8","inputs":{"headers":{"export_enabled":true},"field":{"export_enabled":true},"all_pages":{"export_enabled":true,"data":false},"provider":{"export_enabled":true,"data":"tik_tok"}}},"replace_string_2":{"type":"replace_string","title":"Replace String: video_id","description":"Replaces string or regex with an other string","logging_enabled":false,"error_rules":[],"x":2513,"y":349,"group":"group_8","inputs":{"regex":{"export_enabled":true,"data":"{video_id}"},"pointer":{"export_enabled":true,"data":""},"schema":{"export_enabled":true,"data":"string"}}},"replace_string_3":{"type":"replace_string","title":"Replace String: advertiser_id","description":"Replaces string or regex with an other string","logging_enabled":false,"error_rules":[],"x":2246,"y":340,"group":"group_8","inputs":{"regex":{"export_enabled":true,"data":"{advertiser_id}"},"pointer":{"export_enabled":true,"data":""},"schema":{"export_enabled":true,"data":"string"},"data":{"export_enabled":true,"data":"https://business-api.tiktok.com/open_api/v1.3/file/video/suggestcover/?advertiser_id={advertiser_id}\u0026video_id={video_id}"}}},"extract_4":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":1698,"y":431,"group":"group_8","inputs":{"pointer":{"export_enabled":true,"data":"/0/tiktok/0/id"}}},"extract_v2_3":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":1971,"y":427,"group":"group_8","inputs":{"default_value":{"export_enabled":true},"pointer":{"export_enabled":true,"data":"/id"}}},"patch_json_list_v3_4":{"type":"patch_json_list_v3","logging_enabled":false,"error_rules":[],"x":3080,"y":413,"group":"group_8","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/thumbnail_id","value":"{{inputValue(\"/data/list/0/id\")}}"}]}}},"google_sheets_select_spreadsheet_id_v2_1":{"type":"google_sheets_select_spreadsheet_id_v2","logging_enabled":false,"error_rules":[],"x":1571,"y":31,"inputs":{"range":{"export_enabled":true,"data":"Assets"},"spreadsheet_id":{"title":"spreadsheet_id","description":"The spreadsheet to fetch from"}}},"patch_json_list_v3_5":{"type":"patch_json_list_v3","logging_enabled":false,"error_rules":[],"x":752,"y":343,"inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/name","value":"{{\nconcat(formatTime(timeNow(\"UTC\"), \"%Y-%m-%d\"),\"_\",inputData(\"/name\"))\n}}"}]},"value":{"export_enabled":true}}},"converge_1":{"type":"converge","logging_enabled":false,"error_rules":[],"x":723,"y":276,"group":"group_7"},"data_relay_4":{"type":"data_relay","logging_enabled":false,"error_rules":[],"x":88,"y":520,"group":"group_7"},"patch_json_list_v3_6":{"type":"patch_json_list_v3","logging_enabled":false,"error_rules":[],"x":2439,"y":547,"group":"group_9","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/name","value":"{{inputData(\"/name\")}}_{{formatTime(unixToTime(inputValue(\"\"), \"Europe/London\"), \"%Y-%m-%d\")}}.mp4"}]},"value":{"export_enabled":true},"patch":{"export_enabled":true}}},"replace_list_string_3":{"type":"replace_list_string","logging_enabled":false,"error_rules":[],"x":1621,"y":540,"group":"group_9","inputs":{"value":{"export_enabled":true,"data":""},"regex":{"export_enabled":true,"data":".mp4"},"pointer":{"export_enabled":true,"data":"/name"},"schema":{"export_enabled":true,"data":"any"}}},"timestamp_1":{"type":"timestamp","logging_enabled":false,"error_rules":[],"x":1881,"y":544,"group":"group_9"},"patch_json_v3_2":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":407,"y":257,"group":"group_7","inputs":{"patches":{"export_enabled":true,"data":[]},"value":{"export_enabled":true}}},"concat_1":{"type":"concat","logging_enabled":false,"error_rules":[],"x":2165,"y":538,"group":"group_9","inputs":{"b":{"export_enabled":true},"schema":{"export_enabled":true,"data":"any"}}}},"edges":[{"id":"google_sheets_fetch_table_rows_v3_1.rows:extract_list_1.data_list","points":[]},{"id":"extract_list_1.data_list:if_v2_2.b","points":[]},{"id":"google_sheets_fetch_table_rows_v3_1.fetched:extract_list_1.extract","points":[]},{"id":"if_v2_1.true:extract_1.extract","points":[]},{"id":"input_string_1.string:if_v2_1.b","points":[]},{"id":"if_v2_2.true:trigger_relay_1.relay","points":[]},{"id":"if_v2_1.false:trigger_relay_1.relay","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":"extract_2.extracted:parse_string_to_id_1.parse","points":[]},{"id":"parse_string_to_id_1.parsed:google_drive_download_file_1.download","points":[]},{"id":"extract_2.data:parse_string_to_id_1.value","points":[]},{"id":"parse_string_to_id_1.result:google_drive_download_file_1.file_id","points":[]},{"id":"extract_1.extracted:replace_string_1.replace","points":[]},{"id":"replace_string_1.replaced:if_v2_2.evaluate","points":[]},{"id":"extract_1.data:replace_string_1.data","points":[]},{"id":"replace_string_1.data:if_v2_2.a","points":[]},{"id":"data_relay_1.data:extract_2.data","points":[]},{"id":"for_each_v2_1.item:data_relay_1.data","points":[]},{"id":"tik_tok_select_ad_account_id_1.ad_account_id:data_relay_2.data","points":[]},{"id":"google_sheets_append_table_rows_v3_1.appended:for_each_v2_1.next","points":[]},{"id":"for_each_v2_1.done:stop_1.stop","points":[]},{"id":"google_drive_download_file_1.url:delete_file_1.url","points":[]},{"id":"start_1.start:google_drive_fetch_files_v2_1.fetch","points":[]},{"id":"google_drive_download_file_1.failed:for_each_v2_1.next","points":[]},{"id":"data_relay_2.data:tik_tok_upload_ad_video_1.ad_account_id","points":[]},{"id":"google_drive_download_file_1.url:tik_tok_upload_ad_video_1.url","points":[]},{"id":"data_relay_2.data:tik_tok_fetch_ad_videos_v2_1.ad_account_id","points":[]},{"id":"tik_tok_upload_ad_video_1.uploaded:patch_json_v3_1.patch","points":[]},{"id":"data_relay_1.data:patch_json_list_v3_1.value","points":[]},{"id":"patch_json_list_v3_1.patched:patch_json_list_v3_2.patch","points":[]},{"id":"google_drive_download_file_1.url:patch_json_list_v3_2.value","points":[]},{"id":"patch_json_list_v3_1.data_list:patch_json_list_v3_2.data_list","points":[]},{"id":"google_drive_download_file_1.downloaded:patch_json_list_v3_1.patch","points":[]},{"id":"patch_json_list_v3_2.data_list:patch_json_v3_1.data","points":[]},{"id":"patch_json_v3_1.patched:delete_file_1.delete","points":[]},{"id":"delete_file_1.deleted:extract_3.extract","points":[]},{"id":"patch_json_v3_1.data:extract_3.data","points":[]},{"id":"tik_tok_fetch_ad_videos_v2_1.ad_videos:join_data_1.b","points":[]},{"id":"patch_json_v3_1.data:join_data_1.a","points":[]},{"id":"replace_list_string_1.data_list:replace_list_string_2.data_list","points":[]},{"id":"replace_list_string_1.replaced:replace_list_string_2.replace","points":[]},{"id":"input_any_2.any:map_any_to_table_rows_1.mapping","points":[]},{"id":"map_any_to_table_rows_1.mapped:google_sheets_append_table_rows_v3_1.append","points":[]},{"id":"map_any_to_table_rows_1.rows:google_sheets_append_table_rows_v3_1.rows","points":[]},{"id":"tik_tok_upload_ad_video_1.ad_video_id:patch_json_v3_1.value","points":[]},{"id":"extract_v2_2.data:clone_file_v2_1.url","points":[]},{"id":"data_relay_3.data:patch_json_list_v3_3.data_list","points":[]},{"id":"extract_v2_2.extracted:clone_file_v2_1.clone","points":[]},{"id":"clone_file_v2_1.url:patch_json_list_v3_3.value","points":[]},{"id":"clone_file_v2_1.cloned:patch_json_list_v3_3.patch","points":[]},{"id":"replace_string_3.data:replace_string_2.data","points":[]},{"id":"replace_string_2.data:fetch_integration_url_v2_1.url","points":[]},{"id":"replace_string_2.replaced:fetch_integration_url_v2_1.fetch","points":[]},{"id":"replace_string_3.replaced:replace_string_2.replace","points":[]},{"id":"extract_4.extracted:extract_v2_3.extract","points":[]},{"id":"join_data_1.items:extract_4.data","points":[]},{"id":"data_relay_2.data:extract_v2_3.data","points":[]},{"id":"extract_v2_3.data:replace_string_3.value","points":[]},{"id":"extract_v2_3.extracted:replace_string_3.replace","points":[]},{"id":"extract_4.data:replace_string_2.value","points":[]},{"id":"fetch_integration_url_v2_1.body:patch_json_list_v3_4.value","points":[]},{"id":"fetch_integration_url_v2_1.fetched:patch_json_list_v3_4.patch","points":[]},{"id":"join_data_1.items:patch_json_list_v3_4.data_list","points":[]},{"id":"join_data_1.joined:extract_4.extract","points":[]},{"id":"patch_json_list_v3_4.data_list:data_relay_3.data","points":[]},{"id":"patch_json_list_v3_4.patched:extract_v2_2.extract","points":[]},{"id":"patch_json_list_v3_3.data_list:map_any_to_table_rows_1.data","points":[]},{"id":"patch_json_list_v3_3.patched:map_any_to_table_rows_1.map","points":[]},{"id":"google_drive_fetch_files_v2_1.files:patch_json_list_v3_5.data_list","points":[]},{"id":"google_drive_fetch_files_v2_1.fetched:patch_json_list_v3_5.patch","points":[]},{"id":"patch_json_list_v3_5.data_list:for_each_v2_1.items","points":[]},{"id":"patch_json_list_v3_5.patched:for_each_v2_1.start","points":[]},{"id":"tik_tok_fetch_ad_videos_v2_1.fetched:join_data_1.join","points":[]},{"id":"tik_tok_fetch_ad_videos_v2_1.ad_videos:extract_v2_2.data","points":[]},{"id":"extract_3.extracted:tik_tok_fetch_ad_videos_v2_1.fetch","points":[]},{"id":"extract_3.data:tik_tok_fetch_ad_videos_v2_1.ad_video_ids","points":[]},{"id":"for_each_v2_1.do:extract_2.extract","points":[]},{"id":"patch_json_list_v3_2.data_list:data_relay_4.data","points":[]},{"id":"patch_json_v3_2.patched:converge_1.converge","points":[]},{"id":"extract_v2_1.extracted:tik_tok_upload_ad_video_1.upload","points":[]},{"id":"data_relay_4.data:replace_list_string_3.data_list","points":[]},{"id":"tik_tok_upload_ad_video_1.failed:replace_list_string_3.replace","points":[]},{"id":"converge_1.converged:extract_v2_1.extract","points":[]},{"id":"converge_1.data:extract_v2_1.data","points":[]},{"id":"patch_json_v3_2.data:converge_1.data","points":[]},{"id":"extract_v2_1.data:tik_tok_upload_ad_video_1.file_name","points":[]},{"id":"data_relay_4.data:patch_json_v3_2.data","points":[]},{"id":"replace_list_string_3.replaced:timestamp_1.now","points":[]},{"id":"replace_list_string_3.data_list:patch_json_list_v3_6.data_list","points":[]},{"id":"patch_json_list_v3_2.patched:patch_json_v3_2.patch","points":[]},{"id":"patch_json_list_v3_6.data_list:converge_1.data","points":[]},{"id":"patch_json_list_v3_6.patched:converge_1.converge","points":[]},{"id":"timestamp_1.done:concat_1.concat","points":[]},{"id":"timestamp_1.timestamp:concat_1.a","points":[]}],"groups":{"group_1":{"title":"Skip?","description":"","x":428,"y":1447,"inputs":["input_string_1.string","if_v2_1.evaluate","extract_1.data","if_v2_2.b"],"outputs":["if_v2_2.false","trigger_relay_1.relayed","replace_string_1.data"]},"group_2":{"title":"Get existing assets","description":"","x":76,"y":1439,"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_6":{"title":"Upload Video \u0026 get thumbnail","description":"","x":1458,"y":256,"inputs":["extract_2.extract","data_relay_1.data","data_relay_2.data"],"outputs":["patch_json_list_v3_4.data_list","google_drive_download_file_1.failed","patch_json_list_v3_4.patched","tik_tok_fetch_ad_videos_v2_1.ad_videos"]},"group_3":{"title":"Append Asset to Spreadsheet","description":"","x":1861,"y":255,"inputs":["google_sheets_append_table_rows_v3_1.spreadsheet_id","google_sheets_append_table_rows_v3_1.range","data_relay_3.data","extract_v2_2.extract","extract_v2_2.data"],"outputs":["google_sheets_append_table_rows_v3_1.appended"]},"group_4":{"title":"Store File","description":"","x":1150,"y":186,"group":"group_6","inputs":["extract_2.extract","extract_2.data"],"outputs":["google_drive_download_file_1.failed","google_drive_download_file_1.url","google_drive_download_file_1.downloaded"]},"group_5":{"title":"Get Thumbnail","description":"","x":2739,"y":262,"group":"group_6","inputs":["extract_3.extract","tik_tok_fetch_ad_videos_v2_1.ad_account_id","extract_3.data","join_data_1.a"],"outputs":["join_data_1.items","join_data_1.joined","tik_tok_fetch_ad_videos_v2_1.ad_videos"]},"group_8":{"title":"Get Thumbnail ID","description":"","x":3010,"y":269,"group":"group_6","inputs":["extract_4.extract","extract_4.data","extract_v2_3.data","patch_json_list_v3_4.data_list"],"outputs":["patch_json_list_v3_4.data_list","patch_json_list_v3_4.patched"]},"group_9":{"title":"Add _today to name","description":"","x":1583,"y":513,"group":"group_7","inputs":["replace_list_string_3.data_list","replace_list_string_3.replace"],"outputs":["patch_json_list_v3_6.data_list","patch_json_list_v3_6.patched"]},"group_7":{"title":"Upload Video","description":"","x":2127,"y":283,"group":"group_6","inputs":["tik_tok_upload_ad_video_1.ad_account_id","tik_tok_upload_ad_video_1.url","patch_json_v3_1.data","data_relay_4.data","patch_json_v3_2.patch"],"outputs":["patch_json_v3_1.data","patch_json_v3_1.patched"]}},"widgets":{"widget_1":{"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":"google_drive_fetch_files_v2_1.include_sub_folders"},"widget_2":{"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_3":{"title":"Google Sheet","description":"The ids and names of your uploaded assets will be added here.","position":6,"icon":"","input":"google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id"},"widget_4":{"title":"Ad Account","description":"Select a TikTok Ad Account","position":0,"input":"tik_tok_select_ad_account_id_1.ad_account_id"},"widget_5":{"title":"Folder","description":"Select a folder.","position":2,"input":"google_drive_fetch_files_v2_1.parent_folder_id"}},"variables":{},"config":{"capture_inputs_enabled":false,"caching_enabled":false},"tags":[]}