LinkedIn Bulk Ad Upload

This set of recipes will allow you to launch LinkedIn campaign groups, campaigns and Single Image ads / Single Video ads / Carosuel ads from a GoogleSheet.

Notion image

JSON Recipe

Import the automation recipe(s) into your own account. Don’t know how? Learn here.

Upload Assets to LinkedIn and Export them to Sheet
{"name":"Upload assets (GDrive) \u0026 Export  them to Sheet","description":"upload_assets_gdrive_20221217","nodes":{"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_1","inputs":{"date_time_render_option":{"export_enabled":true,"data":"FORMATTED_STRING"},"value_render_option":{"export_enabled":true,"data":"UNFORMATTED_VALUE"},"dimension":{"export_enabled":true,"data":"ROWS"}}},"extract_list_1":{"type":"extract_list","logging_enabled":false,"error_rules":[],"x":780,"y":406,"group":"group_1","inputs":{"pointer":{"export_enabled":true,"data":"/columns/0"}},"outputs":{"data_list":{"title":"existing_assets","description":"The extracted data"},"extracted":{"title":"extracted","description":"Triggers when the data was extracted"}}},"start_1":{"type":"start","logging_enabled":false,"error_rules":[],"x":27,"y":478},"google_drive_fetch_files_v2_1":{"type":"google_drive_fetch_files_v2","logging_enabled":false,"error_rules":[],"x":516,"y":301,"inputs":{"include_sub_folders":{"export_enabled":true},"parent_folder_id":{"title":"parent_folder_id","description":"Select a folder where all the files you want to fetch are"},"filters":{"export_enabled":true,"data":[]},"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"]}}},"delete_file_1":{"type":"delete_file","logging_enabled":false,"error_rules":[],"x":1196,"y":471,"group":"group_2"},"extract_1":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":379,"y":333,"group":"group_3","inputs":{"pointer":{"export_enabled":true,"data":"/id"}}},"google_drive_download_file_1":{"type":"google_drive_download_file","logging_enabled":false,"error_rules":[],"x":1075,"y":441,"group":"group_3"},"parse_string_to_id_1":{"type":"parse_string_to_id","logging_enabled":false,"error_rules":[],"x":735,"y":372,"group":"group_3","inputs":{"schema":{"export_enabled":true,"data":"google_drive_folder_id"}}},"stop_1":{"type":"stop","logging_enabled":false,"error_rules":[],"x":1074,"y":867},"google_sheets_select_spreadsheet_id_v2_1":{"type":"google_sheets_select_spreadsheet_id_v2","logging_enabled":false,"error_rules":[],"x":112,"y":58,"inputs":{"range":{"export_enabled":true},"spreadsheet_id":{"title":"spreadsheet_id","description":"The spreadsheet to fetch from"}}},"if_v2_1":{"type":"if_v2","logging_enabled":false,"error_rules":[],"x":500,"y":286,"group":"group_4","inputs":{"condition":{"export_enabled":true,"data":"equal"},"a":{"export_enabled":true,"data":"skip"}}},"data_relay_1":{"type":"data_relay","logging_enabled":false,"error_rules":[],"x":79,"y":218,"group":"group_2","inputs":{"data":{"title":"file","description":"Data to relay"}}},"input_string_1":{"type":"input_string","logging_enabled":false,"error_rules":[],"x":136,"y":573,"group":"group_4","inputs":{"string":{"title":"skip?","description":"A string to input","export_enabled":true}}},"if_v2_2":{"type":"if_v2","logging_enabled":false,"error_rules":[],"x":1441,"y":232,"group":"group_4","inputs":{"b":{"title":"existing_assets","description":"Write or paste the data B"},"condition":{"export_enabled":true,"data":"not_in"}},"outputs":{"false":{"title":"skip","description":"Triggers when the evaluation is false"}}},"for_each_v2_1":{"type":"for_each_v2","title":"For Each File","description":"Loops over elements in a list","logging_enabled":false,"max_job_retries":6,"timeout":30,"error_rules":[],"x":830,"y":213,"inputs":{"start":{"title":" start","description":"Starts the first iteration"}}},"trigger_relay_1":{"type":"trigger_relay","logging_enabled":false,"error_rules":[],"x":1873,"y":560,"group":"group_4","outputs":{"relayed":{"title":"upload","description":"Output trigger from relay"}}},"extract_2":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":817,"y":217,"group":"group_4","inputs":{"pointer":{"export_enabled":true,"data":"/name"}}},"trigger_relay_2":{"type":"trigger_relay","logging_enabled":false,"error_rules":[],"x":2607,"y":598,"group":"group_5"},"data_relay_2":{"type":"data_relay","logging_enabled":false,"error_rules":[],"x":286,"y":238,"group":"group_5","inputs":{"data":{"title":"url","description":"Data to relay"}}},"google_sheets_select_spreadsheet_id_v2_2":{"type":"google_sheets_select_spreadsheet_id_v2","logging_enabled":false,"error_rules":[],"x":986,"y":44,"group":"group_5","inputs":{"range":{"title":" range","description":"The range in A1 notation to fetch"},"spreadsheet_id":{"title":" spreadsheet_id","description":"The spreadsheet to fetch from"}}},"if_v2_3":{"type":"if_v2","logging_enabled":false,"error_rules":[],"x":1070,"y":421,"group":"group_6","inputs":{"b":{"export_enabled":true,"data":["video/mp4","image/gif","application/vnd.google-apps.video","video/x-flv","video/MP2T","video/3gpp","video/quicktime","video/x-msvideo","video/x-ms-wmv"]},"condition":{"export_enabled":true,"data":"in"}},"outputs":{"false":{"title":"is_image","description":"Triggers when the evaluation is false"},"true":{"title":"is_video","description":"Triggers when the evaluation is true"}}},"extract_3":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":698,"y":374,"group":"group_6","inputs":{"pointer":{"export_enabled":true,"data":"/mimeType"}},"outputs":{"data":{"title":"mimeType","description":"The extracted data"}}},"data_relay_3":{"type":"data_relay","logging_enabled":false,"error_rules":[],"x":286,"y":383,"group":"group_6","inputs":{"data":{"title":"file","description":"Data to relay"}}},"google_sheets_append_table_rows_v3_1":{"type":"google_sheets_append_table_rows_v3","logging_enabled":false,"error_rules":[],"x":2801,"y":592,"group":"group_7"},"replace_string_1":{"type":"replace_string","logging_enabled":false,"error_rules":[],"x":1124,"y":245,"group":"group_4","inputs":{"value":{"export_enabled":true,"data":""},"regex":{"title":"regex (paste here)","description":"Regex for replacing the string","export_enabled":true,"data":""},"pointer":{"export_enabled":true,"data":""},"schema":{"export_enabled":true,"data":"any"}},"outputs":{"data":{"title":"name","description":"Data that has been partially replaced"}}},"data_relay_4":{"type":"data_relay","logging_enabled":false,"error_rules":[],"x":138,"y":737,"group":"group_5","inputs":{"data":{"title":"name","description":"Data to relay"}}},"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":1123,"y":64,"group":"group_4","inputs":{"any":{"title":"regex (copy me)","description":"Copy this field into the regex field below to remove file endings from your assets. Add any further file endings with the pipe symbol | and the file ending.","export_enabled":true,"data":"\\.(png|mp4|jpg|jpeg|gif|mov|bmp)"}},"outputs":{"any":{"title":" ","description":"The any to input"}}},"linkedin_create_organization_image_v2_1":{"type":"linkedin_create_organization_image_v2","logging_enabled":false,"error_rules":[],"x":639,"y":297,"group":"group_5"},"linkedin_select_organization_id_1":{"type":"linkedin_select_organization_id","logging_enabled":false,"error_rules":[],"x":92,"y":60,"group":"group_5","inputs":{"organization_id":{"export_enabled":true}}},"patch_json_v3_1":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":2291,"y":583,"group":"group_7","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/timestamp","value":"{{inputValue('')}}"}]}}},"delay_1":{"type":"delay","logging_enabled":false,"error_rules":[],"x":1203,"y":998,"group":"group_8","inputs":{"duration":{"export_enabled":true,"data":5}}},"if_v2_4":{"type":"if_v2","logging_enabled":false,"error_rules":[],"x":2031,"y":1158,"group":"group_8","inputs":{"condition":{"export_enabled":true,"data":"equal"},"b":{"export_enabled":true,"data":"PROCESSING"}}},"fetch_integration_url_v2_1":{"type":"fetch_integration_url_v2","logging_enabled":false,"error_rules":[],"x":1458,"y":1001,"group":"group_8","inputs":{"all_pages":{"export_enabled":true,"data":false},"provider":{"export_enabled":true,"data":"linkedin"},"headers":{"export_enabled":true},"field":{"export_enabled":true}}},"if_v2_5":{"type":"if_v2","logging_enabled":false,"error_rules":[],"x":2274,"y":1162,"group":"group_8","inputs":{"b":{"export_enabled":true,"data":"AVAILABLE"},"condition":{"export_enabled":true,"data":"equal"}},"outputs":{"false":{"title":"video_failed","description":"Triggers if the evaluation amounts to false"}}},"extract_v2_1":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":1739,"y":1078,"group":"group_8","inputs":{"pointer":{"export_enabled":true,"data":"/status"},"default_value":{"export_enabled":true}}},"clone_file_v2_1":{"type":"clone_file_v2","logging_enabled":false,"error_rules":[],"x":998,"y":315,"group":"group_5"},"patch_json_v3_2":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1264,"y":315,"group":"group_5","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/url","value":"{{inputValue('')}}"},{"op":"add","path":"/type","value":"image"}]}}},"patch_json_v3_3":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1772,"y":875,"group":"group_5","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/asset_name","value":"{{inputValue('')}}"}]}}},"patch_json_v3_4":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1533,"y":319,"group":"group_5","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/asset_name","value":"{{inputValue('')}}"}]}}},"clone_file_v2_2":{"type":"clone_file_v2","logging_enabled":false,"error_rules":[],"x":1223,"y":882,"group":"group_5"},"linkedin_create_video_1":{"type":"linkedin_create_video","logging_enabled":false,"error_rules":[],"x":644,"y":693,"group":"group_5"},"format_timestamp_v2_1":{"type":"format_timestamp_v2","logging_enabled":false,"error_rules":[],"x":2035,"y":580,"group":"group_7","inputs":{"pattern":{"export_enabled":true,"data":"%Y-%m-%dT%H:%M:%S%z"}}},"patch_json_v3_5":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":946,"y":808,"group":"group_8","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"","value":"https://api.linkedin.com/rest/videos/urn%3Ali%3Avideo%3A{{inputValue(\"/id\")}}"}]},"data":{"export_enabled":true}}},"converge_1":{"type":"converge","logging_enabled":false,"error_rules":[],"x":2109,"y":592,"group":"group_5"},"map_any_to_table_rows_1":{"type":"map_any_to_table_rows","logging_enabled":false,"error_rules":[],"x":2549,"y":588,"group":"group_7","inputs":{"add_header":{"export_enabled":true,"data":false},"mapping":{"export_enabled":true,"data":{"A":"/asset_name","B":"/type","C":"/id","D":"/url","E":"/timestamp"}},"schema":{"export_enabled":true,"data":"any"}}},"patch_json_v3_6":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1502,"y":875,"group":"group_5","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/url","value":"{{inputValue('')}}"},{"op":"add","path":"/type","value":"video"}]}}},"timestamp_1":{"type":"timestamp","logging_enabled":false,"error_rules":[],"x":1777,"y":582,"group":"group_7"}},"edges":[{"id":"google_sheets_fetch_table_rows_v3_1.rows:extract_list_1.data_list","points":[]},{"id":"start_1.start:google_sheets_fetch_table_rows_v3_1.fetch","points":[]},{"id":"extract_list_1.data_list:if_v2_2.b","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":"google_sheets_fetch_table_rows_v3_1.fetched:extract_list_1.extract","points":[]},{"id":"for_each_v2_1.item:extract_2.data","points":[]},{"id":"for_each_v2_1.do:if_v2_1.evaluate","points":[]},{"id":"if_v2_1.true:extract_2.extract","points":[]},{"id":"input_string_1.string:if_v2_1.b","points":[]},{"id":"google_drive_download_file_1.url:data_relay_2.data","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:patch_json_v3_4.data","points":[]},{"id":"patch_json_v3_2.patched:patch_json_v3_4.patch","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_2.spreadsheet_id:google_sheets_append_table_rows_v3_1.spreadsheet_id","points":[]},{"id":"google_sheets_append_table_rows_v3_1.appended:trigger_relay_2.relay","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_2.range:google_sheets_append_table_rows_v3_1.range","points":[]},{"id":"extract_list_1.extracted:google_drive_fetch_files_v2_1.fetch","points":[]},{"id":"google_drive_fetch_files_v2_1.files:for_each_v2_1.items","points":[]},{"id":"if_v2_2.true:trigger_relay_1.relay","points":[]},{"id":"google_drive_fetch_files_v2_1.fetched:for_each_v2_1.start","points":[]},{"id":"if_v2_1.false:trigger_relay_1.relay","points":[]},{"id":"for_each_v2_1.done:stop_1.stop","points":[]},{"id":"data_relay_1.data:data_relay_3.data","points":[]},{"id":"trigger_relay_1.relayed:extract_1.extract","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id:google_sheets_select_spreadsheet_id_v2_2.spreadsheet_id","points":[]},{"id":"for_each_v2_1.item:data_relay_1.data","points":[]},{"id":"delete_file_1.deleted:for_each_v2_1.next","points":[]},{"id":"replace_string_1.data:if_v2_2.a","points":[]},{"id":"data_relay_3.data:extract_3.data","points":[]},{"id":"extract_3.extracted:if_v2_3.evaluate","points":[]},{"id":"extract_3.data:if_v2_3.a","points":[]},{"id":"extract_1.data:parse_string_to_id_1.value","points":[]},{"id":"extract_1.extracted:parse_string_to_id_1.parse","points":[]},{"id":"parse_string_to_id_1.result:google_drive_download_file_1.file_id","points":[]},{"id":"parse_string_to_id_1.parsed:google_drive_download_file_1.download","points":[]},{"id":"google_drive_download_file_1.url:delete_file_1.url","points":[]},{"id":"data_relay_1.data:extract_1.data","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_1.range:google_sheets_select_spreadsheet_id_v2_2.range","points":[]},{"id":"if_v2_2.false:for_each_v2_1.next","points":[]},{"id":"extract_2.data:replace_string_1.data","points":[]},{"id":"replace_string_1.replaced:if_v2_2.evaluate","points":[]},{"id":"replace_string_1.data:data_relay_4.data","points":[]},{"id":"data_relay_4.data:patch_json_v3_4.value","points":[]},{"id":"google_drive_download_file_1.downloaded:extract_3.extract","points":[]},{"id":"trigger_relay_2.relayed:delete_file_1.delete","points":[]},{"id":"extract_2.extracted:replace_string_1.replace","points":[]},{"id":"linkedin_select_organization_id_1.organization_id:linkedin_create_video_1.organization_id","points":[]},{"id":"linkedin_create_organization_image_v2_1.created:clone_file_v2_1.clone","points":[]},{"id":"linkedin_create_video_1.created:patch_json_v3_5.patch","points":[]},{"id":"linkedin_create_video_1.video_id:patch_json_v3_5.value","points":[]},{"id":"patch_json_v3_5.data:fetch_integration_url_v2_1.url","points":[]},{"id":"fetch_integration_url_v2_1.body:extract_v2_1.data","points":[]},{"id":"if_v2_4.true:delay_1.start","points":[]},{"id":"if_v2_4.false:if_v2_5.evaluate","points":[]},{"id":"if_v2_5.false:for_each_v2_1.next","points":[]},{"id":"linkedin_create_video_1.video_id:patch_json_v3_6.data","points":[]},{"id":"if_v2_5.true:clone_file_v2_2.clone","points":[]},{"id":"patch_json_v3_4.data:converge_1.data","points":[]},{"id":"patch_json_v3_3.patched:converge_1.converge","points":[]},{"id":"converge_1.converged:timestamp_1.now","points":[]},{"id":"converge_1.data:patch_json_v3_1.data","points":[]},{"id":"map_any_to_table_rows_1.mapped:google_sheets_append_table_rows_v3_1.append","points":[]},{"id":"if_v2_3.true:linkedin_create_video_1.create","points":[]},{"id":"if_v2_3.false:linkedin_create_organization_image_v2_1.create","points":[]},{"id":"linkedin_select_organization_id_1.organization_id:linkedin_create_organization_image_v2_1.organization_id","points":[]},{"id":"data_relay_2.data:linkedin_create_organization_image_v2_1.url","points":[]},{"id":"data_relay_2.data:clone_file_v2_1.url","points":[]},{"id":"patch_json_v3_5.patched:delay_1.start","points":[]},{"id":"delay_1.delayed:fetch_integration_url_v2_1.fetch","points":[]},{"id":"extract_v2_1.data:if_v2_4.a","points":[]},{"id":"extract_v2_1.extracted:if_v2_4.evaluate","points":[]},{"id":"fetch_integration_url_v2_1.fetched:extract_v2_1.extract","points":[]},{"id":"extract_v2_1.data:if_v2_5.a","points":[]},{"id":"data_relay_2.data:linkedin_create_video_1.url","points":[]},{"id":"linkedin_create_organization_image_v2_1.organization_image_id:patch_json_v3_2.data","points":[]},{"id":"clone_file_v2_2.url:patch_json_v3_6.value","points":[]},{"id":"clone_file_v2_2.cloned:patch_json_v3_6.patch","points":[]},{"id":"patch_json_v3_6.data:patch_json_v3_3.data","points":[]},{"id":"patch_json_v3_6.patched:patch_json_v3_3.patch","points":[]},{"id":"patch_json_v3_1.data:map_any_to_table_rows_1.data","points":[]},{"id":"format_timestamp_v2_1.date_time:patch_json_v3_1.value","points":[]},{"id":"format_timestamp_v2_1.formatted:patch_json_v3_1.patch","points":[]},{"id":"timestamp_1.timestamp:format_timestamp_v2_1.timestamp","points":[]},{"id":"timestamp_1.done:format_timestamp_v2_1.format","points":[]},{"id":"patch_json_v3_1.patched:map_any_to_table_rows_1.map","points":[]},{"id":"data_relay_2.data:clone_file_v2_2.url","points":[]},{"id":"data_relay_4.data:patch_json_v3_3.value","points":[]},{"id":"patch_json_v3_4.patched:converge_1.converge","points":[]},{"id":"patch_json_v3_3.data:converge_1.data","points":[]},{"id":"map_any_to_table_rows_1.rows:google_sheets_append_table_rows_v3_1.rows","points":[]}],"groups":{"group_3":{"title":"Download File","description":"","x":401,"y":434,"group":"group_2","inputs":["extract_1.data","extract_1.extract"],"outputs":["google_drive_download_file_1.url","google_drive_download_file_1.downloaded"]},"group_1":{"title":"Get existing assets","description":"","x":224,"y":414,"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_5":{"title":"Upload and add to Sheet","description":"","x":842,"y":204,"group":"group_2","inputs":["data_relay_2.data","google_sheets_select_spreadsheet_id_v2_2.spreadsheet_id","google_sheets_select_spreadsheet_id_v2_2.range","data_relay_3.data","data_relay_4.data","extract_3.extract"],"outputs":["trigger_relay_2.relayed","if_v2_5.false"]},"group_2":{"title":"Upload File","description":"","x":1458,"y":180,"inputs":["extract_1.extract","google_sheets_select_spreadsheet_id_v2_2.range","google_sheets_select_spreadsheet_id_v2_2.spreadsheet_id","data_relay_1.data","data_relay_4.data"],"outputs":["delete_file_1.deleted","if_v2_5.false"]},"group_4":{"title":"Skip?","description":"","x":1137,"y":451,"inputs":["input_string_1.string","if_v2_1.evaluate","extract_2.data","if_v2_2.b"],"outputs":["if_v2_2.false","trigger_relay_1.relayed","replace_string_1.data"]},"group_6":{"title":"Determine Action","description":"","x":307,"y":424,"group":"group_5","inputs":["data_relay_3.data","extract_3.extract"],"outputs":["if_v2_3.false","if_v2_3.true"]},"group_8":{"title":"Video Processed?","description":"","x":937,"y":876,"group":"group_5","inputs":["patch_json_v3_5.value","patch_json_v3_5.patch"],"outputs":["if_v2_5.false","if_v2_5.true"]},"group_7":{"title":"Append to Sheet","description":"","x":2356,"y":601,"group":"group_5","inputs":["google_sheets_append_table_rows_v3_1.range","google_sheets_append_table_rows_v3_1.spreadsheet_id","patch_json_v3_1.data","timestamp_1.now"],"outputs":["google_sheets_append_table_rows_v3_1.appended"]}},"widgets":{"widget_1":{"title":"Tab / Range","description":"The range in A1 notation.","position":7,"icon":"las la-table","input":"google_sheets_select_spreadsheet_id_v2_1.range"},"widget_2":{"title":"Google Sheet","description":"The ids and names of your uploaded assets will be added here.","position":6,"icon":"","input":"google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id"},"widget_3":{"title":"Skip uploaded assets","description":"If set to \"Skip\", any files already in the tab will be skipped. Note: Check takes place on asset name basis without file extension. E.g. if an asset called `test.png` has been uploaded before and added to the spreadsheet, another asset called `test.mp4` would not be uploaded.","position":5,"icon":"las la-filter","options":[{"data":"skip","title":"Skip"},{"data":"dontskip","title":"Upload all (don't skip)"}],"input":"input_string_1.string"},"widget_4":{"title":"Folder","description":"Select a folder.","position":1,"input":"google_drive_fetch_files_v2_1.parent_folder_id"},"widget_5":{"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,"options":[{"data":true,"title":"TRUE"},{"data":false,"title":"FALSE"}],"input":"google_drive_fetch_files_v2_1.include_sub_folders"},"widget_6":{"title":"Organization ID","description":"Select the organization id","position":-1,"input":"linkedin_select_organization_id_1.organization_id"}},"variables":{},"config":{"capture_inputs_enabled":false,"caching_enabled":false},"tags":[]}
Export Campaigns to Sheet
{"name":"Export Campaigns to Sheet ","description":"A blank recipe","nodes":{"start_1":{"type":"start","logging_enabled":false,"error_rules":[],"x":150,"y":50},"linkedin_fetch_campaigns_1":{"type":"linkedin_fetch_campaigns","logging_enabled":false,"error_rules":[],"x":1607,"y":346,"group":"group_1","inputs":{"effective_status":{"export_enabled":true}}},"for_each_v2_1":{"type":"for_each_v2","logging_enabled":false,"error_rules":[],"x":784,"y":279},"linkedin_fetch_campaign_group_1":{"type":"linkedin_fetch_campaign_group","logging_enabled":false,"error_rules":[],"x":1100,"y":344,"group":"group_1"},"concat_1":{"type":"concat","logging_enabled":false,"error_rules":[],"x":1356,"y":346,"group":"group_1","inputs":{"b":{"export_enabled":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":1496,"y":431,"group":"group_2","inputs":{"add_header":{"export_enabled":true,"data":false},"mapping":{"export_enabled":true,"data":{"A":"/campaign_id","B":"/campaign_name","C":"/campaign_group_id","D":"/campaign_group_name"}},"schema":{"export_enabled":true,"data":"any_list"}}},"linkedin_select_ad_account_id_1":{"type":"linkedin_select_ad_account_id","logging_enabled":false,"error_rules":[],"x":208,"y":145,"inputs":{"ad_account_id":{"export_enabled":true}}},"linkedin_select_campaign_group_ids_1":{"type":"linkedin_select_campaign_group_ids","logging_enabled":false,"error_rules":[],"x":444,"y":362,"inputs":{"campaign_group_ids":{"export_enabled":true}}},"patch_json_list_v3_1":{"type":"patch_json_list_v3","logging_enabled":false,"error_rules":[],"x":1847,"y":347,"group":"group_1","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/campaign_group_id","value":"{{cast(inputValue(\"/id\"), \"string\")}}"},{"op":"add","path":"/campaign_group_name","value":"{{inputValue(\"/name\")}}"},{"op":"add","path":"/campaign_id","value":"{{cast(inputData(\"/id\"), \"string\")}}"},{"op":"add","path":"/campaign_name","value":"{{inputData(\"/name\")}}"},{"op":"remove","path":"/id"}]}}},"data_relay_1":{"type":"data_relay","logging_enabled":false,"error_rules":[],"x":810,"y":717,"group":"group_1","inputs":{"data":{"title":"account_id","description":"Data to relay"}}},"google_sheets_clear_table_rows_v3_1":{"type":"google_sheets_clear_table_rows_v3","logging_enabled":false,"error_rules":[],"x":1796,"y":455,"group":"group_2"},"patch_json_v3_1":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1222,"y":432,"group":"group_2","inputs":{"patch":{"title":"patch","description":"Starts the patching"},"patches":{"export_enabled":true,"data":[{"op":"add","path":"","value":"{{inputValue(\"\")}}!A2:Z"}]},"data":{"export_enabled":true}}},"google_sheets_append_table_rows_v3_1":{"type":"google_sheets_append_table_rows_v3","logging_enabled":false,"error_rules":[],"x":2077,"y":457,"group":"group_2"},"google_sheets_select_spreadsheet_id_v2_1":{"type":"google_sheets_select_spreadsheet_id_v2","logging_enabled":false,"error_rules":[],"x":900,"y":107,"group":"group_2","inputs":{"range":{"export_enabled":true},"spreadsheet_id":{"export_enabled":true}}},"append_1":{"type":"append","logging_enabled":false,"error_rules":[],"x":1351,"y":311,"inputs":{"flatten":{"export_enabled":true,"data":true},"schema":{"export_enabled":true,"data":"any"}}},"stop_1":{"type":"stop","logging_enabled":false,"error_rules":[],"x":1899,"y":461}},"edges":[{"id":"linkedin_fetch_campaigns_1.campaigns:patch_json_list_v3_1.data_list","points":[]},{"id":"linkedin_fetch_campaign_group_1.campaign_group:patch_json_list_v3_1.value","points":[]},{"id":"append_1.resetted:for_each_v2_1.start","points":[]},{"id":"data_relay_1.data:linkedin_fetch_campaigns_1.ad_account_id","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.spreadsheet_id:google_sheets_clear_table_rows_v3_1.spreadsheet_id","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_1.range:patch_json_v3_1.value","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_append_table_rows_v3_1.range","points":[]},{"id":"linkedin_fetch_campaigns_1.fetched:patch_json_list_v3_1.patch","points":[]},{"id":"patch_json_list_v3_1.patched:append_1.append","points":[]},{"id":"append_1.list:map_any_to_table_rows_1.data","points":[]},{"id":"linkedin_select_ad_account_id_1.ad_account_id:data_relay_1.data","points":[]},{"id":"patch_json_v3_1.data:google_sheets_clear_table_rows_v3_1.range","points":[]},{"id":"patch_json_v3_1.patched:map_any_to_table_rows_1.map","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id:google_sheets_append_table_rows_v3_1.spreadsheet_id","points":[]},{"id":"map_any_to_table_rows_1.rows:google_sheets_append_table_rows_v3_1.rows","points":[]},{"id":"for_each_v2_1.done:patch_json_v3_1.patch","points":[]},{"id":"google_sheets_append_table_rows_v3_1.appended:stop_1.stop","points":[]},{"id":"start_1.start:append_1.reset","points":[]},{"id":"append_1.appended:for_each_v2_1.next","points":[]},{"id":"patch_json_list_v3_1.data_list:append_1.item","points":[]},{"id":"data_relay_1.data:linkedin_fetch_campaign_group_1.ad_account_id","points":[]},{"id":"linkedin_select_campaign_group_ids_1.campaign_group_ids:for_each_v2_1.items","points":[]},{"id":"for_each_v2_1.item:linkedin_fetch_campaign_group_1.campaign_group_id","points":[]},{"id":"linkedin_fetch_campaign_group_1.fetched:concat_1.concat","points":[]},{"id":"for_each_v2_1.do:linkedin_fetch_campaign_group_1.fetch","points":[]},{"id":"linkedin_select_ad_account_id_1.ad_account_id:linkedin_select_campaign_group_ids_1.ad_account_id","points":[]},{"id":"for_each_v2_1.item:concat_1.a","points":[]},{"id":"concat_1.done:linkedin_fetch_campaigns_1.fetch","points":[]},{"id":"concat_1.list:linkedin_fetch_campaigns_1.campaign_group_ids","points":[]}],"groups":{"group_1":{"title":"Fetch Campaigns","description":"","x":1072,"y":303,"inputs":["linkedin_fetch_campaign_group_1.campaign_group_id","linkedin_fetch_campaign_group_1.fetch","concat_1.a","data_relay_1.data"],"outputs":["patch_json_list_v3_1.data_list","patch_json_list_v3_1.patched"]},"group_2":{"title":"Update Spreadsheet","description":"","x":1646,"y":327,"inputs":["map_any_to_table_rows_1.data","patch_json_v3_1.patch"],"outputs":["google_sheets_append_table_rows_v3_1.appended"]}},"widgets":{"widget_1":{"title":"Ad Account","description":"Select the ad account id","position":0,"input":"linkedin_select_ad_account_id_1.ad_account_id"},"widget_2":{"title":"Campaigns' Status","description":"Filter only the Campaigns with the specific effective_status","position":2,"input":"linkedin_fetch_campaigns_1.effective_status"},"widget_3":{"title":"Campaigns Groups","description":"Select Campaign Group Ids","position":0,"input":"linkedin_select_campaign_group_ids_1.campaign_group_ids"},"widget_4":{"title":"Tab","description":"Select or enter the range in the selected spreadsheet in 'A1 notation'","position":5,"input":"google_sheets_select_spreadsheet_id_v2_1.range"},"widget_5":{"title":"Spreadsheet","description":"Select or enter id of the spreadsheet","position":4,"input":"google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id"}},"variables":{},"config":{"capture_inputs_enabled":false,"caching_enabled":false},"tags":[]}
Bulk-upload Campaign Groups, Campaigns & Ads
{"name":"Bulk-upload Campaign Groups, Campaigns \u0026 Ads ","description":"tiktok_bulk_create_ads_20230316","nodes":{"data_relay_1":{"type":"data_relay","logging_enabled":false,"error_rules":[],"x":347,"y":151,"group":"group_1","inputs":{"data":{"title":"ad_to_be","description":"Data to relay"}}},"slice_list_v3_1":{"type":"slice_list_v3","logging_enabled":false,"error_rules":[],"x":1031,"y":324,"group":"group_2","inputs":{"to":{"export_enabled":true,"data":-1},"from":{"export_enabled":true,"data":3}}},"map_table_rows_1":{"type":"map_table_rows","logging_enabled":false,"error_rules":[],"x":1345,"y":480,"group":"group_2","inputs":{"schema":{"export_enabled":true,"data":"any"}}},"filter_v2_1":{"type":"filter_v2","logging_enabled":false,"error_rules":[],"x":1645,"y":493,"group":"group_2","inputs":{"filters":{"export_enabled":true,"data":[{"value":"create","pointer":"/data/config/ad_action","operator":"="},{"value":null,"pointer":"/data/output/ad_id","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":1918,"y":500,"group":"group_2","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_2"},"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_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"}}},"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_2","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_3","inputs":{"b":{"export_enabled":true,"data":["new_campaign_into_above_campaign_group","new_campaign_from_template"]},"condition":{"export_enabled":true,"data":"in"}},"outputs":{"false":{"title":"existing_campaign","description":"Triggers when the evaluation is false"},"true":{"title":"   new_campaign","description":"Triggers when the evaluation is true"}}},"extract_1":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":882,"y":332,"group":"group_3","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_3","inputs":{"b":{"export_enabled":true,"data":"new_campaign_group_and_campaign_from_template"},"condition":{"export_enabled":true,"data":"equal"}},"outputs":{"false":{"title":"existing_campaign_group","description":"Triggers when the evaluation is false"},"true":{"title":"  new_campaign_group","description":"Triggers when the evaluation is true"}}},"data_relay_2":{"type":"data_relay","logging_enabled":false,"error_rules":[],"x":277,"y":345,"group":"group_4","inputs":{"data":{"title":"account_id","description":"Data to relay"}}},"extract_v2_1":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":597,"y":333,"group":"group_3","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"}}},"data_relay_3":{"type":"data_relay","logging_enabled":false,"error_rules":[],"x":276,"y":627,"group":"group_4","inputs":{"data":{"title":"ad_to_be","description":"Data to relay"}}},"stop_1":{"type":"stop","title":"Stop","description":"Stops an automation","logging_enabled":true,"error_rules":[],"x":2260,"y":748},"patch_json_v3_1":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1357,"y":418,"group":"group_5","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/runSchedule/start","value":"{{multiply(add(inputValue(\"\"), 60), 1000)}}"}]}}},"linkedin_create_campaign_group_1":{"type":"linkedin_create_campaign_group","logging_enabled":false,"error_rules":[{"error_type":".*","expression":".*"}],"x":1410,"y":160,"group":"group_6","inputs":{"create":{"title":"create","description":"Starts the creation"}},"outputs":{"error":{"title":"campaign_group_error","description":"Contains error details"}}},"timestamp_1":{"type":"timestamp","logging_enabled":false,"error_rules":[],"x":1102,"y":421,"group":"group_5","inputs":{"now":{"title":"now","description":"Outputs the current time"}}},"data_relay_4":{"type":"data_relay","logging_enabled":false,"error_rules":[],"x":488,"y":138,"group":"group_6","inputs":{"data":{"title":"ad_account_id","description":"Data to relay"}}},"for_each_v2_1":{"type":"for_each_v2","title":"For Each","description":"Loops over elements in a list","logging_enabled":false,"error_rules":[],"x":444,"y":274,"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"}}},"patch_json_v3_2":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":808,"y":296,"group":"group_7","inputs":{"patches":{"export_enabled":true,"data":[{"op":"remove","path":"/test"},{"op":"remove","path":"/changeAuditStamps"},{"op":"remove","path":"/servingStatuses"},{"op":"remove","path":"/backfilled"},{"op":"remove","path":"/id"},{"op":"remove","path":"/account"},{"op":"add","path":"/name","value":"{{inputValue(\"/config/campaign_group/name\")}}"},{"op":"replace","path":"/status","value":"DRAFT"}]}}},"patch_json_v3_3":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":525,"y":248,"group":"group_8","inputs":{"patch":{"title":"patch","description":"Starts the patching"},"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/id","value":"{{inputValue(\"/config/campaign/id\")}}"}]},"data":{"export_enabled":true,"data":{"id":"","provider":"linkedin","type":"campaign"}}}},"patch_json_v3_4":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":826,"y":292,"group":"group_9","inputs":{"patches":{"export_enabled":true,"data":[{"op":"remove","path":"/storyDeliveryEnabled"},{"op":"remove","path":"/targetingCriteria"},{"op":"remove","path":"/pacingStrategy"},{"op":"remove","path":"/id"},{"op":"remove","path":"/changeAuditStamps"},{"op":"remove","path":"/costType"},{"op":"remove","path":"/creativeSelection"},{"op":"remove","path":"/test"},{"op":"remove","path":"/servingStatuses"},{"op":"remove","path":"/version"},{"op":"remove","path":"/associatedEntity"},{"op":"remove","path":"/offsitePreferences"},{"op":"remove","path":"/campaignGroup"},{"op":"remove","path":"/unitCost"},{"op":"remove","path":"/account"},{"op":"add","path":"/name","value":"{{inputValue(\"/config/campaign/name\")}}"},{"op":"add","path":"/format","value":"{{\nswitch(\n    inputValue(\"/config/post/type\"), \n        \"Single Image Ad\", \"STANDARD_UPDATE\",\n        \"Single Video Ad\", \"SINGLE_VIDEO\",\n        \"Carousel\", \"CAROUSEL\"\n    )\n}}"}]}}},"data_relay_5":{"type":"data_relay","logging_enabled":false,"error_rules":[],"x":320,"y":563,"group":"group_1","inputs":{"data":{"title":"ad_account_id","description":"Data to relay"}}},"converge_1":{"type":"converge","logging_enabled":false,"error_rules":[],"x":1661,"y":345,"group":"group_9","outputs":{"data":{"title":"campaign_group_id","description":"The data from the path the node was triggered from"}}},"if_v2_3":{"type":"if_v2","logging_enabled":false,"error_rules":[],"x":1073,"y":298,"group":"group_9","inputs":{"b":{"export_enabled":true,"data":["new_campaign_group_and_campaign_from_template","new_campaign_into_above_campaign_group"]},"condition":{"export_enabled":true,"data":"in"},"a":{"title":"action","description":"Write or paste the data A"}}},"patch_json_v3_5":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1348,"y":522,"group":"group_9","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/id","value":"{{inputValue(\"/config/campaign_group/id\")}}"}]},"data":{"export_enabled":true,"data":{"id":"","provider":"linkedin","type":"campaign_group"}}}},"patch_json_v3_6":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1348,"y":139,"group":"group_9","inputs":{"patches":{"export_enabled":true,"data":[]},"value":{"title":"value","description":"A value that can be used in patches"},"data":{"title":"campaign_group_id","description":"Input the data to apply the patches to"}}},"linkedin_fetch_campaign_1":{"type":"linkedin_fetch_campaign","logging_enabled":false,"error_rules":[],"x":810,"y":253,"group":"group_8"},"linkedin_create_campaign_1":{"type":"linkedin_create_campaign","logging_enabled":false,"error_rules":[{"error_type":".*","expression":".*"}],"x":1449,"y":206,"group":"group_1","inputs":{"create":{"title":"create","description":"Starts the creation"}},"outputs":{"error":{"title":"campaign_error","description":"Contains error details"}}},"patch_json_v3_7":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1489,"y":406,"group":"group_10","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/runSchedule/start","value":"{{multiply(add(inputValue(\"\"), 60), 1000)}}"},{"op":"replace","path":"/runSchedule/end","value":"{{multiply(add(inputValue(\"\"), 100000), 1000)}}"}]}}},"timestamp_2":{"type":"timestamp","logging_enabled":false,"error_rules":[],"x":1234,"y":409,"group":"group_10","inputs":{"now":{"title":"now","description":"Outputs the current time"}}},"linkedin_fetch_campaign_group_1":{"type":"linkedin_fetch_campaign_group","logging_enabled":false,"error_rules":[],"x":1093,"y":161,"group":"group_11"},"extract_v2_2":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":590,"y":161,"group":"group_11","inputs":{"extract":{"title":"extract","description":"Starts the extraction"},"default_value":{"export_enabled":true},"pointer":{"export_enabled":true,"data":"/config/campaign_group/id"}}},"parse_string_to_id_1":{"type":"parse_string_to_id","logging_enabled":false,"error_rules":[],"x":838,"y":158,"group":"group_11","inputs":{"schema":{"export_enabled":true,"data":"linkedin_campaign_group_id"}}},"data_relay_6":{"type":"data_relay","logging_enabled":false,"error_rules":[],"x":251,"y":651,"group":"group_9","inputs":{"data":{"title":"ad_to_be","description":"Data to relay"}}},"extract_v2_3":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":598,"y":230,"group":"group_4","inputs":{"extract":{"title":"extract","description":"Starts the extraction"},"pointer":{"export_enabled":true,"data":"/config/post/type"},"default_value":{"export_enabled":true}}},"if_v2_4":{"type":"if_v2","logging_enabled":false,"error_rules":[],"x":873,"y":230,"group":"group_4","inputs":{"b":{"export_enabled":true,"data":"Single Image Ad"},"condition":{"export_enabled":true,"data":"equal"}},"outputs":{"true":{"title":"single_image_ad","description":"Triggers if the evaluation amounts to true"}}},"patch_json_v3_8":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1215,"y":248,"group":"group_4","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/contentCallToActionLabel","value":"{{inputValue(\"/config/post/cta\")}}"},{"op":"replace","path":"/content/article/description","value":"{{inputValue(\"/config/post/description\")}}"},{"op":"replace","path":"/content/article/thumbnail","value":"urn:li:image:{{inputValue(\"/config/post/asset1\")}}"},{"op":"replace","path":"/content/article/title","value":"{{inputValue(\"/config/post/title1\")}}"},{"op":"replace","path":"/content/article/source","value":"{{inputValue(\"/config/post/landingpage1\")}}"},{"op":"replace","path":"/contentLandingPage","value":"{{inputValue(\"/config/post/landingpage1\")}}"},{"op":"replace","path":"/commentary","value":"{{inputValue(\"/config/post/commentary\")}}"},{"op":"replace","path":"/adContext/dscName","value":"{{inputValue(\"/config/post/ad_name\")}}"}]},"data":{"export_enabled":true,"data":{"lifecycleState":"PUBLISHED","visibility":"PUBLIC","contentCallToActionLabel":"","distribution":{"feedDistribution":"NONE","thirdPartyDistributionChannels":[]},"content":{"article":{"thumbnail":"","source":"","title":"Go go go","description":""}},"contentLandingPage":"","isReshareDisabledByAuthor":false,"commentary":"","adContext":{"dscAdAccount":"","dscStatus":"ACTIVE"}}}}},"linkedin_create_post_1":{"type":"linkedin_create_post","logging_enabled":false,"error_rules":[{"error_type":".*","expression":".*"}],"x":2705,"y":540,"group":"group_12","inputs":{"create":{"title":"create","description":"Starts the creation"}},"outputs":{"error":{"title":"post_error","description":"Contains error details"}}},"linkedin_create_creative_1":{"type":"linkedin_create_creative","logging_enabled":false,"error_rules":[{"error_type":".*","expression":".*"}],"x":3726,"y":542,"group":"group_13","inputs":{"create":{"title":"create","description":"Starts the creation"}},"outputs":{"error":{"title":"creative_error","description":"Contains error details"}}},"patch_json_v3_9":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":2960,"y":540,"group":"group_13","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/content/reference","value":"{{inputValue(\"/id\")}}"}]},"data":{"export_enabled":true,"data":{"content":{"reference":""},"intendedStatus":"DRAFT"}}}},"data_relay_7":{"type":"data_relay","logging_enabled":false,"error_rules":[],"x":488,"y":345,"group":"group_6","inputs":{"data":{"title":"ad_to_be","description":"Data to relay"}}},"converge_2":{"type":"converge","logging_enabled":false,"error_rules":[],"x":2189,"y":541,"group":"group_12"},"linkedin_select_ad_account_id_1":{"type":"linkedin_select_ad_account_id","logging_enabled":false,"error_rules":[],"x":517,"y":41,"inputs":{"ad_account_id":{"export_enabled":true}}},"if_v2_5":{"type":"if_v2","logging_enabled":false,"error_rules":[],"x":1239,"y":579,"group":"group_4","inputs":{"b":{"export_enabled":true,"data":"Single Video Ad"},"condition":{"export_enabled":true,"data":"equal"}},"outputs":{"false":{"title":"carousel_ad","description":"Triggers if the evaluation amounts to false"},"true":{"title":"single_video_ad","description":"Triggers if the evaluation amounts to true"}}},"patch_json_v3_10":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1567,"y":632,"group":"group_4","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/contentCallToActionLabel","value":"{{inputValue(\"/config/post/cta\")}}"},{"op":"replace","path":"/content/media/id","value":"urn:li:video:{{inputValue(\"/config/post/asset1\")}}"},{"op":"replace","path":"/content/media/title","value":"{{inputValue(\"/config/post/title1\")}}"},{"op":"replace","path":"/contentLandingPage","value":"{{inputValue(\"/config/post/landingpage1\")}}"},{"op":"replace","path":"/commentary","value":"{{inputValue(\"/config/post/commentary\")}}"},{"op":"replace","path":"/adContext/dscName","value":"{{inputValue(\"/config/post/ad_name\")}}"}]},"patch":{"title":"patch","description":"Starts the patching"},"data":{"export_enabled":true,"data":{"lifecycleState":"PUBLISHED","visibility":"PUBLIC","contentCallToActionLabel":"","adContext":{"dscAdAccount":"","dscStatus":"ACTIVE"},"distribution":{"feedDistribution":"NONE","thirdPartyDistributionChannels":[]},"content":{"media":{"title":"","id":""}},"contentLandingPage":"","isReshareDisabledByAuthor":false,"commentary":""}}}},"patch_json_v3_11":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1569,"y":899,"group":"group_4","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/contentLandingPage","value":"{{inputValue(\"/config/post/landingpage1\")}}"},{"op":"replace","path":"/commentary","value":"{{inputValue(\"/config/post/commentary\")}}"},{"op":"replace","path":"/adContext/dscName","value":"{{inputValue(\"/config/post/ad_name\")}}"}]},"data":{"export_enabled":true,"data":{"adContext":{"dscAdAccount":"","dscStatus":"ACTIVE"},"commentary":"sample commentary","visibility":"PUBLIC","distribution":{"feedDistribution":"NONE","targetEntities":[],"thirdPartyDistributionChannels":[]},"lifecycleState":"PUBLISHED","isReshareDisabledByAuthor":false,"content":{"carousel":{"cards":[]}},"contentLandingPage":""}},"patch":{"title":"patch","description":"Starts the patching"}}},"process_script_1":{"type":"process_script","logging_enabled":false,"error_rules":[],"x":1850,"y":920,"group":"group_4","inputs":{"process":{"title":"process","description":"Starts the processing"},"src":{"export_enabled":true,"data":"import json\r\n\r\n# Input JSON strings\r\nobj1 = inputs['a']\r\n\r\nobj2 = inputs['b']\r\n\r\n# Extract the post object\r\npost = obj2['config']['post']\r\n\r\n# Iterate over the keys in the post object and create new card objects\r\nfor i in range(1, 11):\r\n    title_key = f'title{i}'\r\n    landing_page_key = f'landingpage{i}'\r\n    asset_key = f'asset{i}'\r\n\r\n    if title_key in post and landing_page_key in post and asset_key in post:\r\n        new_card = {\r\n            \"media\": {\r\n                \"id\": f\"urn:li:image:{post[asset_key]}\",\r\n                \"title\": post[title_key]\r\n            },\r\n            \"landingPage\": post[landing_page_key] \r\n\r\n        }\r\n        # Append the new card to the cards list in the carousel\r\n        obj1['content']['carousel']['cards'].append(new_card)\r\n\r\n# Convert the updated object to JSON string\r\noutputs['a'] = obj1\r\n"},"runtime":{"export_enabled":true,"data":"python3_7"}}},"patch_json_v3_12":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":2452,"y":541,"group":"group_12","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/adContext/dscAdAccount","value":"urn:li:sponsoredAccount:{{inputValue(\"/id\")}}"}]}}},"patch_json_v3_13":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1158,"y":1440,"group":"group_14","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/error","value":"{{inputValue('/data/message')}}"},{"op":"add","path":"/status","value":"Campaign Group error"}]},"patch":{"title":"if_campaign_group_error","description":"Starts the patching"},"value":{"title":"campaign_group_error","description":"A value that can be used in patches"},"data":{"export_enabled":true,"data":{}}}},"patch_json_v3_14":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1155,"y":1150,"group":"group_14","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/error","value":"{{inputValue('/data/message')}}"},{"op":"add","path":"/status","value":"Campaign error"}]},"patch":{"title":"if_campaign_error","description":"Starts the patching"},"value":{"title":"campaign_error","description":"A value that can be used in patches"},"data":{"export_enabled":true,"data":{}}}},"converge_3":{"type":"converge","logging_enabled":false,"error_rules":[],"x":1476,"y":917,"group":"group_14"},"patch_json_v3_15":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1146,"y":578,"group":"group_14","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/error","value":"{{inputValue('/data/message')}}"},{"op":"add","path":"/status","value":"Ad error"}]},"value":{"title":"creative_error","description":"A value that can be used in patches"},"patch":{"title":"if_creative_error","description":"Starts the patching"},"data":{"export_enabled":true,"data":{}}}},"patch_json_v3_16":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1135,"y":870,"group":"group_14","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/error","value":"{{inputValue('/data/message')}}"},{"op":"add","path":"/status","value":"Post error"}]},"value":{"title":"post_error","description":"A value that can be used in patches"},"patch":{"title":"if_post_error","description":"Starts the patching"},"data":{"export_enabled":true,"data":{}}}},"patch_json_v3_17":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1139,"y":265,"group":"group_14","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/status","value":"done"},{"op":"add","path":"/creative_id","value":"{{inputValue(\"/id\")}}"}]},"value":{"title":"creative_id","description":"Input any value that can be used in patches"},"patch":{"title":"if_creative_created","description":"Starts the patching"},"data":{"export_enabled":true,"data":{}}},"outputs":{"data":{"title":"output","description":"The patched data"}}},"patch_json_v3_18":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":2116,"y":904,"group":"group_14","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/0","value":"{{inputValue('')}}"}]},"data":{"title":"data","description":"The data the patches are applied to","export_enabled":true,"data":[]}}},"unmap_table_rows_1":{"type":"unmap_table_rows","logging_enabled":false,"error_rules":[],"x":2421,"y":921,"group":"group_14","inputs":{"unmap":{"title":"unmap","description":"Starts the unmapping"},"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":2696,"y":937,"group":"group_14","inputs":{"update":{"title":"update","description":"Starts the update"}}},"data_relay_8":{"type":"data_relay","logging_enabled":false,"error_rules":[],"x":1487,"y":660,"group":"group_14","inputs":{"data":{"title":"ad_row","description":"Data to relay"}}},"linkedin_select_organization_id_1":{"type":"linkedin_select_organization_id","logging_enabled":false,"error_rules":[],"x":228,"y":42,"inputs":{"organization_id":{"export_enabled":true}}},"extract_v2_4":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":2933,"y":976,"group":"group_14","inputs":{"pointer":{"export_enabled":true,"data":"/error"},"default_value":{"export_enabled":true}}},"patch_json_v3_19":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1818,"y":897,"group":"group_14","inputs":{"patches":{"export_enabled":true,"data":[{"op":"remove","path":"/data"},{"op":"add","path":"/data/output","value":"{{inputValue('')}}"},{"op":"add","path":"/data/config/ad_action","value":"{{inputValue('/status')}}"}]},"patch":{"title":"patch","description":"Starts the patching"}}},"present_1":{"type":"present","logging_enabled":false,"error_rules":[],"x":3229,"y":1142,"group":"group_14","outputs":{"false":{"title":"updated","description":"Triggers if the data does not exist"},"true":{"title":"abort_automation","description":"Triggers if the data exists"}}},"patch_json_v3_20":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":3483,"y":547,"group":"group_13","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/id","value":"{{if(equals(inputValue(\"/0/config/action\"), \"insert_into_existing_campaign\"), inputValue(\"/0/config/campaign/id\"), inputValue(\"/1/id\"))}}"}]},"data":{"export_enabled":true,"data":{"id":"283940593","provider":"linkedin","type":"campaign"}}}},"concat_1":{"type":"concat","logging_enabled":false,"error_rules":[],"x":3238,"y":539,"group":"group_13","inputs":{"b":{"title":"campaign_id","description":"Input data to concat"},"schema":{"export_enabled":true,"data":"any"}}}},"edges":[{"id":"if_v2_5.true:patch_json_v3_10.patch","points":[]},{"id":"if_v2_5.false:patch_json_v3_11.patch","points":[]},{"id":"data_relay_3.data:patch_json_v3_11.value","points":[]},{"id":"linkedin_fetch_campaign_group_1.campaign_group:patch_json_v3_2.data","points":[]},{"id":"data_relay_4.data:linkedin_fetch_campaign_group_1.ad_account_id","points":[]},{"id":"extract_v2_2.data:parse_string_to_id_1.value","points":[]},{"id":"data_relay_7.data:extract_v2_2.data","points":[]},{"id":"parse_string_to_id_1.result:linkedin_fetch_campaign_group_1.campaign_group_id","points":[]},{"id":"if_v2_2.true:extract_v2_2.extract","points":[]},{"id":"extract_v2_2.extracted:parse_string_to_id_1.parse","points":[]},{"id":"linkedin_fetch_campaign_group_1.fetched:patch_json_v3_2.patch","points":[]},{"id":"timestamp_1.timestamp:patch_json_v3_1.value","points":[]},{"id":"patch_json_v3_2.patched:timestamp_1.now","points":[]},{"id":"data_relay_4.data:linkedin_create_campaign_group_1.ad_account_id","points":[]},{"id":"parse_string_to_id_1.parsed:linkedin_fetch_campaign_group_1.fetch","points":[]},{"id":"data_relay_7.data:patch_json_v3_2.value","points":[]},{"id":"data_relay_6.data:patch_json_v3_5.value","points":[]},{"id":"timestamp_1.done:patch_json_v3_1.patch","points":[]},{"id":"data_relay_1.data:data_relay_6.data","points":[]},{"id":"data_relay_6.data:patch_json_v3_4.value","points":[]},{"id":"linkedin_select_ad_account_id_1.ad_account_id:data_relay_4.data","points":[]},{"id":"patch_json_v3_2.data:patch_json_v3_1.data","points":[]},{"id":"data_relay_1.data:patch_json_v3_3.value","points":[]},{"id":"patch_json_v3_3.data:linkedin_fetch_campaign_1.campaign_id","points":[]},{"id":"linkedin_select_ad_account_id_1.ad_account_id:data_relay_2.data","points":[]},{"id":"data_relay_5.data:linkedin_fetch_campaign_1.ad_account_id","points":[]},{"id":"linkedin_select_ad_account_id_1.ad_account_id:data_relay_5.data","points":[]},{"id":"data_relay_5.data:linkedin_create_campaign_1.ad_account_id","points":[]},{"id":"linkedin_fetch_campaign_1.fetched:patch_json_v3_4.patch","points":[]},{"id":"patch_json_v3_3.patched:linkedin_fetch_campaign_1.fetch","points":[]},{"id":"linkedin_fetch_campaign_1.campaign:patch_json_v3_4.data","points":[]},{"id":"patch_json_v3_4.data:patch_json_v3_7.data","points":[]},{"id":"linkedin_create_campaign_group_1.campaign_group_id:patch_json_v3_6.data","points":[]},{"id":"timestamp_2.timestamp:patch_json_v3_7.value","points":[]},{"id":"timestamp_2.done:patch_json_v3_7.patch","points":[]},{"id":"converge_1.converged:timestamp_2.now","points":[]},{"id":"converge_1.data:linkedin_create_campaign_1.campaign_group_id","points":[]},{"id":"linkedin_create_campaign_group_1.created:patch_json_v3_3.patch","points":[]},{"id":"patch_json_list_v2_1.patched:for_each_v2_1.start","points":[]},{"id":"extract_v2_1.data:extract_1.data","points":[]},{"id":"extract_v2_1.extracted:extract_1.extract","points":[]},{"id":"for_each_v2_1.do:extract_v2_1.extract","points":[]},{"id":"for_each_v2_1.item:extract_v2_1.data","points":[]},{"id":"extract_v2_1.data:data_relay_7.data","points":[]},{"id":"extract_v2_1.data:data_relay_1.data","points":[]},{"id":"extract_v2_1.data:data_relay_3.data","points":[]},{"id":"google_sheets_fetch_table_rows_v3_1.rows:slice_list_v3_1.data_list","points":[]},{"id":"if_v2_3.true:patch_json_v3_6.patch","points":[]},{"id":"if_v2_3.false:patch_json_v3_5.patch","points":[]},{"id":"patch_json_v3_6.data:converge_1.data","points":[]},{"id":"patch_json_v3_5.data:converge_1.data","points":[]},{"id":"patch_json_v3_5.patched:converge_1.converge","points":[]},{"id":"patch_json_v3_6.patched:converge_1.converge","points":[]},{"id":"data_relay_8.data:patch_json_v3_19.data","points":[]},{"id":"patch_json_v3_19.data:patch_json_v3_18.value","points":[]},{"id":"patch_json_v3_19.patched:patch_json_v3_18.patch","points":[]},{"id":"patch_json_v3_18.patched:unmap_table_rows_1.unmap","points":[]},{"id":"patch_json_v3_18.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_3.converged:patch_json_v3_19.patch","points":[]},{"id":"converge_3.data:patch_json_v3_19.value","points":[]},{"id":"patch_json_v3_17.data:converge_3.data","points":[]},{"id":"patch_json_v3_15.patched:converge_3.converge","points":[]},{"id":"patch_json_v3_15.data:converge_3.data","points":[]},{"id":"patch_json_v3_17.patched:converge_3.converge","points":[]},{"id":"patch_json_v3_16.patched:converge_3.converge","points":[]},{"id":"patch_json_v3_16.data:converge_3.data","points":[]},{"id":"unmap_table_rows_1.unmapped:google_sheets_update_table_rows_v2_1.update","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_13.data:converge_3.data","points":[]},{"id":"patch_json_v3_13.patched:converge_3.converge","points":[]},{"id":"patch_json_v3_14.data:converge_3.data","points":[]},{"id":"patch_json_v3_14.patched:converge_3.converge","points":[]},{"id":"for_each_v2_1.item:data_relay_8.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":"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_1.data:if_v2_2.a","points":[]},{"id":"extract_1.data:if_v2_1.a","points":[]},{"id":"extract_1.extracted:if_v2_2.evaluate","points":[]},{"id":"if_v2_2.false:if_v2_1.evaluate","points":[]},{"id":"extract_1.data:if_v2_3.a","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":"data_relay_2.data:patch_json_v3_12.value","points":[]},{"id":"linkedin_create_post_1.created:patch_json_v3_9.patch","points":[]},{"id":"data_relay_2.data:linkedin_create_creative_1.ad_account_id","points":[]},{"id":"patch_json_v3_4.patched:if_v2_3.evaluate","points":[]},{"id":"patch_json_v3_8.data:converge_2.data","points":[]},{"id":"converge_2.converged:patch_json_v3_12.patch","points":[]},{"id":"data_relay_3.data:patch_json_v3_10.value","points":[]},{"id":"patch_json_v3_10.data:converge_2.data","points":[]},{"id":"patch_json_v3_11.data:process_script_1.a","points":[]},{"id":"process_script_1.a:converge_2.data","points":[]},{"id":"process_script_1.processed:converge_2.converge","points":[]},{"id":"patch_json_v3_1.patched:linkedin_create_campaign_group_1.create","points":[]},{"id":"patch_json_v3_1.data:linkedin_create_campaign_group_1.data","points":[]},{"id":"patch_json_v3_7.patched:linkedin_create_campaign_1.create","points":[]},{"id":"data_relay_3.data:extract_v2_3.data","points":[]},{"id":"extract_v2_3.data:if_v2_4.a","points":[]},{"id":"if_v2_4.false:if_v2_5.evaluate","points":[]},{"id":"if_v2_4.true:patch_json_v3_8.patch","points":[]},{"id":"data_relay_3.data:patch_json_v3_8.value","points":[]},{"id":"extract_v2_3.data:if_v2_5.a","points":[]},{"id":"patch_json_v3_8.patched:converge_2.converge","points":[]},{"id":"converge_2.data:patch_json_v3_12.data","points":[]},{"id":"extract_v2_3.extracted:if_v2_4.evaluate","points":[]},{"id":"patch_json_v3_10.patched:converge_2.converge","points":[]},{"id":"patch_json_v3_12.patched:linkedin_create_post_1.create","points":[]},{"id":"linkedin_create_campaign_1.created:extract_v2_3.extract","points":[]},{"id":"patch_json_v3_11.patched:process_script_1.process","points":[]},{"id":"if_v2_1.true:patch_json_v3_3.patch","points":[]},{"id":"if_v2_1.false:extract_v2_3.extract","points":[]},{"id":"linkedin_create_post_1.post_id:patch_json_v3_9.value","points":[]},{"id":"data_relay_3.data:process_script_1.b","points":[]},{"id":"linkedin_create_creative_1.failed:patch_json_v3_15.patch","points":[]},{"id":"linkedin_create_creative_1.error:patch_json_v3_15.value","points":[]},{"id":"linkedin_create_post_1.error:patch_json_v3_16.value","points":[]},{"id":"linkedin_create_campaign_1.failed:patch_json_v3_14.patch","points":[]},{"id":"linkedin_create_campaign_group_1.failed:patch_json_v3_13.patch","points":[]},{"id":"linkedin_create_creative_1.created:patch_json_v3_17.patch","points":[]},{"id":"linkedin_create_creative_1.creative_id:patch_json_v3_17.value","points":[]},{"id":"linkedin_create_post_1.failed:patch_json_v3_16.patch","points":[]},{"id":"linkedin_create_campaign_1.error:patch_json_v3_14.value","points":[]},{"id":"linkedin_create_campaign_group_1.error:patch_json_v3_13.value","points":[]},{"id":"patch_json_v3_7.data:linkedin_create_campaign_1.data","points":[]},{"id":"for_each_v2_1.done:stop_1.stop","points":[]},{"id":"patch_json_list_v2_1.data_list:for_each_v2_1.items","points":[]},{"id":"linkedin_select_organization_id_1.organization_id:linkedin_create_post_1.organization_id","points":[]},{"id":"converge_3.data:extract_v2_4.data","points":[]},{"id":"patch_json_v3_9.data:linkedin_create_creative_1.data","points":[]},{"id":"extract_v2_4.data:present_1.data","points":[]},{"id":"extract_v2_4.extracted:present_1.check","points":[]},{"id":"google_sheets_update_table_rows_v2_1.updated:extract_v2_4.extract","points":[]},{"id":"present_1.true:stop_1.stop","points":[]},{"id":"present_1.false:for_each_v2_1.next","points":[]},{"id":"patch_json_v3_12.data:linkedin_create_post_1.data","points":[]},{"id":"patch_json_v3_9.patched:concat_1.concat","points":[]},{"id":"data_relay_3.data:concat_1.a","points":[]},{"id":"linkedin_create_campaign_1.campaign_id:concat_1.b","points":[]},{"id":"concat_1.list:patch_json_v3_20.value","points":[]},{"id":"concat_1.done:patch_json_v3_20.patch","points":[]},{"id":"patch_json_v3_20.patched:linkedin_create_creative_1.create","points":[]},{"id":"patch_json_v3_20.data:linkedin_create_creative_1.campaign_id","points":[]}],"groups":{"group_6":{"title":"Create Campaign Group","description":"","x":1081,"y":230,"inputs":["data_relay_7.data","data_relay_4.data","extract_v2_2.extract"],"outputs":["linkedin_create_campaign_group_1.campaign_group_id","linkedin_create_campaign_group_1.created","linkedin_create_campaign_group_1.error","linkedin_create_campaign_group_1.failed"]},"group_3":{"title":"Control Flow","description":"","x":752,"y":296,"inputs":["extract_v2_1.extract","extract_v2_1.data"],"outputs":["if_v2_2.true","extract_1.data","if_v2_1.false","if_v2_1.true","extract_v2_1.data"]},"group_4":{"title":"Create Ad","description":"","x":1652,"y":231,"inputs":["concat_1.b","data_relay_2.data","data_relay_3.data","extract_v2_3.extract","linkedin_create_post_1.organization_id"],"outputs":["linkedin_create_post_1.error","linkedin_create_creative_1.creative_id","linkedin_create_creative_1.created","linkedin_create_creative_1.error","linkedin_create_creative_1.failed","linkedin_create_post_1.failed"]},"group_2":{"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_1":{"title":"Create Campaign","description":"","x":1377,"y":247,"inputs":["if_v2_3.a","data_relay_1.data","data_relay_5.data","patch_json_v3_6.data","patch_json_v3_3.patch"],"outputs":["linkedin_create_campaign_1.campaign_id","linkedin_create_campaign_1.created","linkedin_create_campaign_1.error","linkedin_create_campaign_1.failed"]},"group_9":{"title":"Prepare New Campaign","description":"","x":1127,"y":400,"group":"group_1","inputs":["patch_json_v3_4.data","patch_json_v3_4.patch","if_v2_3.a","patch_json_v3_6.data","data_relay_6.data"],"outputs":["converge_1.data","patch_json_v3_7.patched","patch_json_v3_7.data"]},"group_8":{"title":"Fetch Campaign","description":"","x":804,"y":224,"group":"group_1","inputs":["patch_json_v3_3.value","patch_json_v3_3.patch","linkedin_fetch_campaign_1.ad_account_id"],"outputs":["linkedin_fetch_campaign_1.campaign","linkedin_fetch_campaign_1.fetched"]},"group_5":{"title":"Add Start Time","description":"","x":1069,"y":303,"group":"group_7","inputs":["timestamp_1.now","patch_json_v3_1.data"],"outputs":["patch_json_v3_1.data","patch_json_v3_1.patched"]},"group_10":{"title":"Add Start and End Times","description":"","x":1921,"y":355,"group":"group_9","inputs":["timestamp_2.now","patch_json_v3_7.data"],"outputs":["patch_json_v3_7.data","patch_json_v3_7.patched"]},"group_7":{"title":"Prepare New Campaign Group","description":"","x":1097,"y":389,"group":"group_6","inputs":["patch_json_v3_2.value","patch_json_v3_2.patch","patch_json_v3_2.data"],"outputs":["patch_json_v3_1.patched","patch_json_v3_1.data"]},"group_11":{"title":"Fetch Campaign Group","description":"","x":845,"y":169,"group":"group_6","inputs":["linkedin_fetch_campaign_group_1.ad_account_id","extract_v2_2.data","extract_v2_2.extract"],"outputs":["linkedin_fetch_campaign_group_1.campaign_group","linkedin_fetch_campaign_group_1.fetched"]},"group_14":{"title":"Update Sheet","description":"","x":1945,"y":239,"inputs":["unmap_table_rows_1.mapping","google_sheets_update_table_rows_v2_1.spreadsheet_id","data_relay_8.data","patch_json_v3_15.patch","patch_json_v3_15.value","patch_json_v3_16.patch","patch_json_v3_16.value","patch_json_v3_13.patch","patch_json_v3_17.patch","patch_json_v3_17.value","patch_json_v3_14.patch","patch_json_v3_14.value","patch_json_v3_13.value"],"outputs":["present_1.true","present_1.false"]},"group_12":{"title":"Create Post","description":"","x":2219,"y":524,"group":"group_4","inputs":["linkedin_create_post_1.organization_id","converge_2.converge","converge_2.data","patch_json_v3_12.value"],"outputs":["linkedin_create_post_1.post_id","linkedin_create_post_1.error","linkedin_create_post_1.failed","linkedin_create_post_1.created"]},"group_13":{"title":"Create Creative","description":"","x":2470,"y":524,"group":"group_4","inputs":["linkedin_create_creative_1.ad_account_id","patch_json_v3_9.value","patch_json_v3_9.patch","concat_1.b","concat_1.a"],"outputs":["linkedin_create_creative_1.creative_id","linkedin_create_creative_1.error","linkedin_create_creative_1.failed","linkedin_create_creative_1.created"]}},"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":"Tab","description":"The range in A1 notation to fetch","position":2,"input":"google_sheets_select_spreadsheet_id_v2_1.range"},"widget_3":{"title":"Ad Account","description":"Select the ad account id","position":0,"input":"linkedin_select_ad_account_id_1.ad_account_id"},"widget_4":{"title":"Organization","description":"Select the organization id","position":-1,"input":"linkedin_select_organization_id_1.organization_id"}},"variables":{},"config":{"capture_inputs_enabled":false,"caching_enabled":false},"tags":[]}

How To

Step 1: Create Spreadsheet & automations

Create automations from all above recipes and duplicate this spreadsheet.

Step 2: Export Campaigns

Export your Campaignswith the “Export Campaignsto sheet” recipe. Here you simply need to choose your account as well as the right spreadsheet that you have setup before and the “Campaigns” tab. Any of the exported Campaignscan be used as templates (to be duplicated) or to launch new ads into existing ones.

Step 3: Upload & Export Assets

Setup the “Upload Assets (GDrive)” recipe to upload your creatives. Choose the folder where your videos have been uploaded, the ad account, organization and the same spreadsheet as before and the “Assets” tab.

Step 4: Fill Spreadsheet and Run Automation to Create Ads

Now you can start filling out each mandatory field and set each row in the “Create” column to “create”. One row equals one new ad.

Most columns are self-explanatory, so here are just a few that may require further explanation.

 

Ad Format:

We currently Support Single Image Ads, Single Video Ads and Carousel Ads.

 

Action:

In each row, one new ad will be created.

With the "Action" field, you can determine whether the ad should be launched into an existing adgroup or whether you would like to create a new adgroup or even campaign.

Options:

  • Duplicate campaign within campaign croup: “Campaign Name” required
  • Duplicate campaign group and campaign: “Campaign Name” and “Adgroup Name” required
  • Instert into selected campaign
  • Insert into last (above) campaign
    • [requires at least one row above where a campaign was duplicated]

  • Duplicate campaign into above campaign group: “Campaign Name” required
    • [requires at least one row above where a campaign was duplicated]

 

Now, with all data setup correctly and available in the sheet, you can create ads, campaignsand campaign groups.

Make sure to choose the correct spreadsheet and “create” tab and hit “Run Automation”.

 

After running the automation, you will receive the ad id back into your sheet. Also the “create” column will be set to “done”.

 
Notion image
 

Connected FAQs

 
Did this answer your question?
😞
😐
🤩

Last updated on December 14, 2023