Bulk Campaign, Adsets & Ad Renaming

Export all campaigns, adsets & ads

{"name":"Export all campaigns, adsets \u0026 ads","description":"export_adsets_gsheets_20220530","nodes":{"start_1":{"type":"start","logging_enabled":false,"x":42,"y":143},"stop_1":{"type":"stop","logging_enabled":false,"x":1831,"y":1152},"fb_fetch_adsets_v2_1":{"type":"fb_fetch_adsets_v2","logging_enabled":false,"x":1078,"y":637},"fb_select_ad_account_ids_v2_1":{"type":"fb_select_ad_account_ids_v2","logging_enabled":false,"x":76,"y":310},"fb_fetch_campaign_ids_v2_1":{"type":"fb_fetch_campaign_ids_v2","logging_enabled":false,"x":357,"y":313,"inputs":{"effective_status":{"export_enabled":true,"data":["ACTIVE"]},"is_completed":{"export_enabled":true,"data":false}}},"fb_fetch_campaign_adset_ids_v2_1":{"type":"fb_fetch_campaign_adset_ids_v2","logging_enabled":false,"x":600,"y":316,"inputs":{"effective_status":{"export_enabled":true,"data":["ACTIVE"]},"is_completed":{"export_enabled":true,"data":false}}},"fb_fetch_campaigns_v2_1":{"type":"fb_fetch_campaigns_v2","logging_enabled":false,"x":1073,"y":968},"fb_fetch_adset_ad_ids_v2_1":{"type":"fb_fetch_adset_ad_ids_v2","logging_enabled":false,"x":839,"y":317,"inputs":{"effective_status":{"export_enabled":true,"data":["PAUSED","ACTIVE"]}}},"fb_fetch_ads_v2_1":{"type":"fb_fetch_ads_v2","logging_enabled":false,"x":1078,"y":319},"google_sheets_append_table_rows_v3_1":{"type":"google_sheets_append_table_rows_v3","logging_enabled":false,"x":1548,"y":318,"inputs":{"range":{"export_enabled":true,"data":"ads"}}},"map_any_to_table_rows_1":{"type":"map_any_to_table_rows","logging_enabled":false,"x":1314,"y":965,"inputs":{"add_header":{"export_enabled":true,"data":false},"mapping":{"export_enabled":true,"data":{"A":"/name","B":"/id","C":"/status"}},"schema":{"export_enabled":true,"data":"any_list"}}},"google_sheets_append_table_rows_v3_2":{"type":"google_sheets_append_table_rows_v3","logging_enabled":false,"x":1561,"y":962,"inputs":{"range":{"export_enabled":true,"data":"campaigns"}}},"google_sheets_select_spreadsheet_id_v2_1":{"type":"google_sheets_select_spreadsheet_id_v2","logging_enabled":false,"x":1570,"y":44,"inputs":{"spreadsheet_id":{"export_enabled":true},"range":{"export_enabled":true}}},"map_any_to_table_rows_2":{"type":"map_any_to_table_rows","logging_enabled":false,"x":1315,"y":637,"inputs":{"add_header":{"export_enabled":true,"data":false},"mapping":{"export_enabled":true,"data":{"A":"/name","B":"/id","C":"/status"}},"schema":{"export_enabled":true,"data":"any_list"}}},"google_sheets_append_table_rows_v3_3":{"type":"google_sheets_append_table_rows_v3","logging_enabled":false,"x":1554,"y":636,"inputs":{"range":{"export_enabled":true,"data":"adsets"}}},"map_any_to_table_rows_3":{"type":"map_any_to_table_rows","logging_enabled":false,"x":1312,"y":318,"inputs":{"add_header":{"export_enabled":true,"data":false},"mapping":{"export_enabled":true,"data":{"A":"/name","B":"/id","C":"/status"}},"schema":{"export_enabled":true,"data":"any_list"}}}},"edges":["fb_fetch_campaign_ids_v2_1.campaign_ids:fb_fetch_campaign_adset_ids_v2_1.campaign_ids","fb_fetch_campaign_adset_ids_v2_1.adset_ids:fb_fetch_adsets_v2_1.adset_ids","fb_select_ad_account_ids_v2_1.ad_account_ids:fb_fetch_campaign_ids_v2_1.ad_account_ids","start_1.start:fb_fetch_campaign_ids_v2_1.fetch","fb_fetch_campaign_ids_v2_1.campaign_ids:fb_fetch_campaigns_v2_1.campaign_ids","fb_fetch_campaign_adset_ids_v2_1.adset_ids:fb_fetch_adset_ad_ids_v2_1.adset_ids","fb_fetch_campaign_ids_v2_1.fetched:fb_fetch_campaign_adset_ids_v2_1.fetch","fb_fetch_campaign_adset_ids_v2_1.fetched:fb_fetch_adset_ad_ids_v2_1.fetch","fb_fetch_adset_ad_ids_v2_1.ad_ids:fb_fetch_ads_v2_1.ad_ids","fb_fetch_adset_ad_ids_v2_1.fetched:fb_fetch_ads_v2_1.fetch","google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id:google_sheets_append_table_rows_v3_1.spreadsheet_id","google_sheets_append_table_rows_v3_1.appended:fb_fetch_adsets_v2_1.fetch","map_any_to_table_rows_2.mapped:google_sheets_append_table_rows_v3_3.append","map_any_to_table_rows_2.rows:google_sheets_append_table_rows_v3_3.rows","fb_fetch_adsets_v2_1.fetched:map_any_to_table_rows_2.map","fb_fetch_adsets_v2_1.adsets:map_any_to_table_rows_2.data","map_any_to_table_rows_1.mapped:google_sheets_append_table_rows_v3_2.append","map_any_to_table_rows_1.rows:google_sheets_append_table_rows_v3_2.rows","fb_fetch_campaigns_v2_1.fetched:map_any_to_table_rows_1.map","google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id:google_sheets_append_table_rows_v3_2.spreadsheet_id","google_sheets_append_table_rows_v3_3.appended:fb_fetch_campaigns_v2_1.fetch","fb_fetch_campaigns_v2_1.campaigns:map_any_to_table_rows_1.data","google_sheets_append_table_rows_v3_2.appended:stop_1.stop","google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id:google_sheets_append_table_rows_v3_3.spreadsheet_id","fb_fetch_ads_v2_1.fetched:map_any_to_table_rows_3.map","fb_fetch_ads_v2_1.ads:map_any_to_table_rows_3.data","map_any_to_table_rows_3.rows:google_sheets_append_table_rows_v3_1.rows","map_any_to_table_rows_3.mapped:google_sheets_append_table_rows_v3_1.append"],"groups":{},"widgets":{"widget_1":{"title":"Ad Accounts","description":"Select one or more Facebook Accounts","position":0,"input":"fb_select_ad_account_ids_v2_1.ad_account_ids"},"widget_2":{"title":"Campaign Status","description":"effective status of campaigns","position":1,"input":"fb_fetch_campaign_ids_v2_1.effective_status"},"widget_3":{"title":"Spreadsheet","description":"The spreadsheet to fetch from","position":0,"input":"google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id"},"widget_4":{"title":"Ad Set Status","description":"effective status of adset","position":2,"input":"fb_fetch_campaign_adset_ids_v2_1.effective_status"},"widget_5":{"title":"Ad Status","description":"effective status of ad","position":3,"input":"fb_fetch_adset_ad_ids_v2_1.effective_status"}},"variables":{},"config":{"capture_inputs_enabled":false,"caching_enabled":false},"tags":[]}

Update any name

{"name":"Update any name","description":"A blank recipe","nodes":{"start_1":{"type":"start","logging_enabled":false,"x":150,"y":50},"map_table_rows_to_any_1":{"type":"map_table_rows_to_any","logging_enabled":false,"x":665,"y":75,"inputs":{"mapping":{"export_enabled":true,"data":{"A":"/new_name","B":"/id"}},"schema":{"export_enabled":true,"data":"any_list"}}},"filter_v2_1":{"type":"filter_v2","logging_enabled":false,"x":961,"y":69,"inputs":{"filters":{"export_enabled":true,"data":[{"operator":"!=","pointer":"/new_name","value":null},{"operator":"not_contains","pointer":"/id","value":"ID"}]}}},"stop_1":{"type":"stop","logging_enabled":false,"x":1713,"y":595},"google_sheets_fetch_table_rows_v3_1":{"type":"google_sheets_fetch_table_rows_v3","logging_enabled":false,"x":389,"y":75,"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,"data":"campaigns"}}},"google_sheets_select_spreadsheet_id_v2_1":{"type":"google_sheets_select_spreadsheet_id_v2","logging_enabled":false,"x":55,"y":517,"inputs":{"spreadsheet_id":{"export_enabled":true},"range":{"export_enabled":true}}},"fb_update_campaigns_1":{"type":"fb_update_campaigns","logging_enabled":false,"x":1263,"y":91,"inputs":{"batch_size":{"export_enabled":true,"data":50}}},"google_sheets_fetch_table_rows_v3_2":{"type":"google_sheets_fetch_table_rows_v3","logging_enabled":false,"x":388,"y":445,"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,"data":"adsets"}}},"map_table_rows_to_any_2":{"type":"map_table_rows_to_any","logging_enabled":false,"x":662,"y":441,"inputs":{"mapping":{"export_enabled":true,"data":{"A":"/new_name","B":"/id"}},"schema":{"export_enabled":true,"data":"any_list"}}},"filter_v2_2":{"type":"filter_v2","logging_enabled":false,"x":951,"y":439,"inputs":{"filters":{"export_enabled":true,"data":[{"operator":"!=","pointer":"/new_name","value":"null"},{"operator":"not_contains","pointer":"/id","value":"Ad Id"}]}}},"fb_update_adsets_1":{"type":"fb_update_adsets","logging_enabled":false,"x":1268,"y":445,"inputs":{"batch_size":{"export_enabled":true,"data":50}}},"google_sheets_fetch_table_rows_v3_3":{"type":"google_sheets_fetch_table_rows_v3","logging_enabled":false,"x":390,"y":789,"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,"data":"ads"}}},"map_table_rows_to_any_3":{"type":"map_table_rows_to_any","logging_enabled":false,"x":664,"y":785,"inputs":{"mapping":{"export_enabled":true,"data":{"A":"/new_name","B":"/id"}},"schema":{"export_enabled":true,"data":"any_list"}}},"filter_v2_3":{"type":"filter_v2","logging_enabled":false,"x":953,"y":783,"inputs":{"filters":{"export_enabled":true,"data":[{"operator":"!=","pointer":"/new_name","value":null},{"operator":"not_contains","pointer":"/id","value":"Ad Id"}]}}},"fb_update_ads_1":{"type":"fb_update_ads","logging_enabled":false,"x":1268,"y":789,"inputs":{"batch_size":{"export_enabled":true,"data":50}}}},"edges":["start_1.start:google_sheets_fetch_table_rows_v3_1.fetch","google_sheets_fetch_table_rows_v3_1.rows:map_table_rows_to_any_1.rows","google_sheets_fetch_table_rows_v3_1.fetched:map_table_rows_to_any_1.map","google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id:google_sheets_fetch_table_rows_v3_1.spreadsheet_id","map_table_rows_to_any_1.data:filter_v2_1.items","map_table_rows_to_any_2.data:filter_v2_2.items","filter_v2_2.filtered:fb_update_adsets_1.update","google_sheets_fetch_table_rows_v3_2.rows:map_table_rows_to_any_2.rows","google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id:google_sheets_fetch_table_rows_v3_2.spreadsheet_id","filter_v2_3.filtered:fb_update_ads_1.update","map_table_rows_to_any_3.data:filter_v2_3.items","google_sheets_fetch_table_rows_v3_3.fetched:map_table_rows_to_any_3.map","google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id:google_sheets_fetch_table_rows_v3_3.spreadsheet_id","fb_update_ads_1.updated:stop_1.stop","map_table_rows_to_any_1.mapped:filter_v2_1.filter","filter_v2_1.items:fb_update_campaigns_1.data_list","filter_v2_1.filtered:fb_update_campaigns_1.update","filter_v2_2.items:fb_update_adsets_1.data_list","map_table_rows_to_any_2.mapped:filter_v2_2.filter","google_sheets_fetch_table_rows_v3_2.fetched:map_table_rows_to_any_2.map","filter_v2_3.items:fb_update_ads_1.data_list","map_table_rows_to_any_3.mapped:filter_v2_3.filter","google_sheets_fetch_table_rows_v3_3.rows:map_table_rows_to_any_3.rows","fb_update_adsets_1.updated:google_sheets_fetch_table_rows_v3_3.fetch","fb_update_campaigns_1.updated:google_sheets_fetch_table_rows_v3_2.fetch"],"groups":{},"widgets":{"widget_1":{"title":"Spreadsheet","description":"The spreadsheet to fetch from","position":0,"input":"google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id"},"widget_2":{"title":"Campaign Tab","description":"The range in A1 notation to fetch","position":2,"input":"google_sheets_fetch_table_rows_v3_1.range"},"widget_3":{"title":"Adset Tab","description":"The range in A1 notation to fetch","position":3,"input":"google_sheets_fetch_table_rows_v3_2.range"},"widget_4":{"title":"Ad Tab","description":"The range in A1 notation to fetch","position":4,"input":"google_sheets_fetch_table_rows_v3_3.range"}},"variables":{},"config":{"capture_inputs_enabled":false,"caching_enabled":false},"tags":[]}