Pinterest Bulk Pin/Ad Uploading

This set of recipes helps you to create pins & launch ads from a Google Spreadsheet to Pinterest.

JSON Recipe

Import all automation recipes into your account. Don’t know how? Learn here.

  1. Export Boards into the sheet: This automation exports Pinterest board IDs to the Spreadsheet. It fetches the board details from the Pinterest API, maps the relevant data, and appends it to the specified spreadsheet tab boards.
Export Boards into sheet
{"name":"Export Boards","description":"A blank recipe","nodes":{"google_sheets_clear_table_rows_v3_1":{"type":"google_sheets_clear_table_rows_v3","logging_enabled":false,"error_rules":[],"x":754,"y":120,"group":"group_1"},"google_sheets_select_spreadsheet_id_v2_1":{"type":"google_sheets_select_spreadsheet_id_v2","logging_enabled":false,"error_rules":[],"x":458,"y":460,"group":"group_1","inputs":{"spreadsheet_id":{"export_enabled":true},"range":{"export_enabled":true,"data":"boards"}}},"start_1":{"type":"start","logging_enabled":false,"error_rules":[],"x":150,"y":50},"stop_1":{"type":"stop","logging_enabled":false,"error_rules":[],"x":944,"y":236},"google_sheets_append_table_rows_v3_1":{"type":"google_sheets_append_table_rows_v3","logging_enabled":false,"error_rules":[],"x":1038,"y":105,"group":"group_1"},"map_any_to_table_rows_1":{"type":"map_any_to_table_rows","logging_enabled":false,"error_rules":[],"x":499,"y":103,"group":"group_1","inputs":{"add_header":{"export_enabled":true,"data":true},"mapping":{"export_enabled":true,"data":{"A":"/name","B":"/id"}},"schema":{"export_enabled":true,"data":"any_list"}}},"fetch_integration_url_v2_1":{"type":"fetch_integration_url_v2","title":"Fetch Boards","description":"Executes a GET request to the endpoint of an integration","logging_enabled":false,"max_job_retries":6,"timeout":30,"error_rules":[],"x":334,"y":96,"group":"group_2","inputs":{"headers":{"export_enabled":true},"field":{"export_enabled":true},"all_pages":{"export_enabled":true},"url":{"export_enabled":true,"data":"https://api.pinterest.com/v5/boards"},"provider":{"export_enabled":true,"data":"pinterest"}}},"extract_v2_1":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":605,"y":146,"group":"group_2","inputs":{"default_value":{"export_enabled":true},"pointer":{"export_enabled":true,"data":"/items"}},"outputs":{"extracted":{"title":"extracted","description":"Triggers when the data was extracted"}}}},"edges":[{"id":"start_1.start:fetch_integration_url_v2_1.fetch","points":[]},{"id":"fetch_integration_url_v2_1.body:extract_v2_1.data","points":[]},{"id":"fetch_integration_url_v2_1.fetched:extract_v2_1.extract","points":[]},{"id":"extract_v2_1.extracted:map_any_to_table_rows_1.map","points":[]},{"id":"extract_v2_1.data:map_any_to_table_rows_1.data","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:google_sheets_clear_table_rows_v3_1.range","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.spreadsheet_id:google_sheets_append_table_rows_v3_1.spreadsheet_id","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_1.range:google_sheets_append_table_rows_v3_1.range","points":[]},{"id":"map_any_to_table_rows_1.rows:google_sheets_append_table_rows_v3_1.rows","points":[]},{"id":"google_sheets_append_table_rows_v3_1.appended:stop_1.stop","points":[]}],"groups":{"group_1":{"title":"Update Sheet","description":"","x":639,"y":98,"inputs":["map_any_to_table_rows_1.data","map_any_to_table_rows_1.map"],"outputs":["google_sheets_append_table_rows_v3_1.appended"]},"group_2":{"title":"Fetch Boards","description":"","x":394,"y":102,"inputs":["fetch_integration_url_v2_1.fetch"],"outputs":["extract_v2_1.data","extract_v2_1.extracted"]}},"widgets":{"widget_1":{"title":"Tab","description":"Select or enter the range in the selected spreadsheet in 'A1 notation'","position":0,"input":"google_sheets_select_spreadsheet_id_v2_1.range"},"widget_2":{"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":[]}
  1. Export Ad Groups into sheet: This automation exports Pinterest ad groups to the Google Spreadsheet, It fetches the ad groups from the Pinterest API, maps the relevant data, and appends it to the specified spreadsheet tab groups.
Export Ad Groups into sheet
{"name":"Export Ad Groups","description":"A blank recipe","nodes":{"google_sheets_clear_table_rows_v3_1":{"type":"google_sheets_clear_table_rows_v3","logging_enabled":false,"error_rules":[],"x":754,"y":120,"group":"group_1"},"google_sheets_select_spreadsheet_id_v2_1":{"type":"google_sheets_select_spreadsheet_id_v2","logging_enabled":false,"error_rules":[],"x":458,"y":475,"group":"group_1","inputs":{"spreadsheet_id":{"export_enabled":true},"range":{"export_enabled":true,"data":"adgroups"}}},"start_1":{"type":"start","logging_enabled":false,"error_rules":[],"x":150,"y":50},"stop_1":{"type":"stop","logging_enabled":false,"error_rules":[],"x":944,"y":236},"google_sheets_append_table_rows_v3_1":{"type":"google_sheets_append_table_rows_v3","logging_enabled":false,"error_rules":[],"x":1038,"y":105,"group":"group_1"},"map_any_to_table_rows_1":{"type":"map_any_to_table_rows","logging_enabled":false,"error_rules":[],"x":499,"y":103,"group":"group_1","inputs":{"add_header":{"export_enabled":true,"data":true},"mapping":{"export_enabled":true,"data":{"A":"/name","B":"/id"}},"schema":{"export_enabled":true,"data":"any_list"}}},"pinterest_fetch_ad_groups_1":{"type":"pinterest_fetch_ad_groups","logging_enabled":false,"error_rules":[],"x":375,"y":38,"inputs":{"operational_status":{"export_enabled":true},"ad_account_id":{"export_enabled":true}}}},"edges":[{"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:google_sheets_clear_table_rows_v3_1.range","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.spreadsheet_id:google_sheets_append_table_rows_v3_1.spreadsheet_id","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_1.range:google_sheets_append_table_rows_v3_1.range","points":[]},{"id":"map_any_to_table_rows_1.rows:google_sheets_append_table_rows_v3_1.rows","points":[]},{"id":"google_sheets_append_table_rows_v3_1.appended:stop_1.stop","points":[]},{"id":"start_1.start:pinterest_fetch_ad_groups_1.fetch","points":[]},{"id":"pinterest_fetch_ad_groups_1.fetched:map_any_to_table_rows_1.map","points":[]},{"id":"pinterest_fetch_ad_groups_1.ad_groups:map_any_to_table_rows_1.data","points":[]}],"groups":{"group_1":{"title":"Update Sheet","description":"","x":639,"y":98,"inputs":["map_any_to_table_rows_1.data","map_any_to_table_rows_1.map"],"outputs":["google_sheets_append_table_rows_v3_1.appended"]}},"widgets":{"widget_1":{"title":"Tab","description":"Select or enter the range in the selected spreadsheet in 'A1 notation'","position":1,"input":"google_sheets_select_spreadsheet_id_v2_1.range"},"widget_2":{"title":"Spreadsheet","description":"Select or enter id of the spreadsheet","position":0,"input":"google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id"},"widget_3":{"title":"Ad Account","description":"Select or enter the id of the ad account from which you want to fetch the ad groups","position":-19,"input":"pinterest_fetch_ad_groups_1.ad_account_id"},"widget_4":{"title":"Ad Groups' Status","description":"Set a filter for the operational status of the ad groups","position":-15,"icon":"las la-battery-half","input":"pinterest_fetch_ad_groups_1.operational_status"}},"variables":{},"config":{"capture_inputs_enabled":false,"caching_enabled":false},"tags":[]}
  1. Create Pins from sheet: This automation allows you to create pins on Pinterest using the inputs in the sheet and updates the spreadsheet with the IDs of the created pins.
Bulk Pin Creation
{"name":"Bulk Pin Creation","description":"A blank recipe","nodes":{"start_1":{"type":"start","logging_enabled":false,"error_rules":[],"x":150,"y":50},"stop_1":{"type":"stop","logging_enabled":false,"error_rules":[],"x":842,"y":566},"for_each_v2_1":{"type":"for_each_v2","logging_enabled":false,"error_rules":[],"x":565,"y":261,"inputs":{"next":{"title":"next","description":"Starts the next iteration"},"start":{"title":"start","description":"Starts the first iteration"}}},"google_sheets_fetch_table_row_mapping_1":{"type":"google_sheets_fetch_table_row_mapping","logging_enabled":false,"error_rules":[],"x":487,"y":377,"group":"group_1"},"google_sheets_fetch_table_rows_v3_1":{"type":"google_sheets_fetch_table_rows_v3","logging_enabled":false,"error_rules":[],"x":808,"y":99,"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"}}},"google_sheets_select_spreadsheet_id_v2_1":{"type":"google_sheets_select_spreadsheet_id_v2","logging_enabled":false,"error_rules":[],"x":187,"y":200,"group":"group_1","inputs":{"spreadsheet_id":{"export_enabled":true},"range":{"export_enabled":true,"data":"pins"}}},"filter_v2_1":{"type":"filter_v2","logging_enabled":false,"error_rules":[],"x":1324,"y":357,"group":"group_1","inputs":{"filters":{"export_enabled":true,"data":[{"operator":"=","pointer":"/data/output/ad_action","value":"create"},{"operator":"=","pointer":"/data/output/pin_id","value":null}]}},"outputs":{"filtered":{"title":"filtered","description":"Triggered when the list was filtered"}}},"patch_json_v2_1":{"type":"patch_json_v2","logging_enabled":false,"error_rules":[],"x":1800,"y":153,"group":"group_2","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/0","value":"{{input.value}}"}]},"data":{"title":"data","description":"The data the patches are applied to","export_enabled":true,"data":[]}}},"patch_json_v3_1":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1529,"y":131,"group":"group_2","inputs":{"patches":{"export_enabled":true,"data":[{"op":"remove","path":"/data"},{"op":"add","path":"/data/output","value":"{{inputValue('')}}"},{"op":"add","path":"/data/config/status","value":""}]}},"outputs":{"patched":{"title":"patched","description":"Triggers when the patches were applied"}}},"unmap_table_rows_1":{"type":"unmap_table_rows","logging_enabled":false,"error_rules":[],"x":2104,"y":105,"group":"group_2","inputs":{"schema":{"export_enabled":true,"data":"any"}},"outputs":{"unmapped":{"title":"unmapped","description":"Triggered when mapped"}}},"google_sheets_update_table_rows_v2_1":{"type":"google_sheets_update_table_rows_v2","logging_enabled":false,"error_rules":[],"x":2414,"y":138,"group":"group_2","outputs":{"updated":{"title":"updated","description":"Triggered when the rows were updated"}}},"data_relay_1":{"type":"data_relay","logging_enabled":false,"error_rules":[],"x":1219,"y":16,"group":"group_2","inputs":{"data":{"title":"ad_row","description":"Data to relay"}}},"converge_1":{"type":"converge","logging_enabled":false,"error_rules":[],"x":1195,"y":230,"group":"group_2"},"patch_json_v2_2":{"type":"patch_json_v2","title":"if_error","description":"Apply JSON patches against data","logging_enabled":false,"max_job_retries":6,"timeout":30,"error_rules":[],"x":857,"y":390,"group":"group_2","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/error","value":"{{input.value/data/error/message}}"},{"op":"add","path":"/ad_action","value":"Error"}]},"value":{"title":"error","description":"A value that can be used in patches"},"data":{"export_enabled":true,"data":{}},"patch":{"title":"if_ad_error","description":"Starts the patching"}}},"patch_json_v3_2":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":849,"y":59,"group":"group_2","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/pin_id","value":"{{inputValue('/id')}}"},{"op":"add","path":"/ad_action","value":"done"}]},"data":{"export_enabled":true,"data":{}},"patch":{"title":"if_success","description":"Starts the patching"}},"outputs":{"data":{"title":"output","description":"The patched data"}}},"map_table_rows_1":{"type":"map_table_rows","logging_enabled":false,"error_rules":[],"x":1054,"y":376,"group":"group_1","inputs":{"schema":{"export_enabled":true,"data":"any"}}},"post_integration_url_v2_1":{"type":"post_integration_url_v2","logging_enabled":false,"error_rules":[{"error_type":".*","expression":".*"}],"x":1136,"y":255,"group":"group_3","inputs":{"headers":{"export_enabled":true},"url":{"export_enabled":true,"data":"https://api.pinterest.com/v5/pins"},"provider":{"export_enabled":true,"data":"pinterest"}}},"extract_v2_1":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":831,"y":284,"group":"group_3","inputs":{"default_value":{"export_enabled":true},"pointer":{"export_enabled":true,"data":"/data/pin"}}}},"edges":[{"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.spreadsheet_id:google_sheets_fetch_table_row_mapping_1.spreadsheet_id","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_1.range:google_sheets_fetch_table_row_mapping_1.range","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_1.range:google_sheets_fetch_table_rows_v3_1.range","points":[]},{"id":"start_1.start:google_sheets_fetch_table_row_mapping_1.fetch","points":[]},{"id":"google_sheets_fetch_table_row_mapping_1.fetched:google_sheets_fetch_table_rows_v3_1.fetch","points":[]},{"id":"filter_v2_1.filtered:for_each_v2_1.start","points":[]},{"id":"filter_v2_1.items:for_each_v2_1.items","points":[]},{"id":"for_each_v2_1.item:extract_v2_1.data","points":[]},{"id":"for_each_v2_1.do:extract_v2_1.extract","points":[]},{"id":"extract_v2_1.extracted:post_integration_url_v2_1.post","points":[]},{"id":"data_relay_1.data:patch_json_v3_1.data","points":[]},{"id":"patch_json_v3_1.data:patch_json_v2_1.value","points":[]},{"id":"patch_json_v3_1.patched:patch_json_v2_1.patch","points":[]},{"id":"patch_json_v2_1.patched:unmap_table_rows_1.unmap","points":[]},{"id":"patch_json_v2_1.data:unmap_table_rows_1.mapped_rows","points":[]},{"id":"unmap_table_rows_1.rows:google_sheets_update_table_rows_v2_1.rows","points":[]},{"id":"unmap_table_rows_1.unmapped:google_sheets_update_table_rows_v2_1.update","points":[]},{"id":"converge_1.converged:patch_json_v3_1.patch","points":[]},{"id":"converge_1.data:patch_json_v3_1.value","points":[]},{"id":"patch_json_v3_2.data:converge_1.data","points":[]},{"id":"patch_json_v2_2.patched:converge_1.converge","points":[]},{"id":"patch_json_v2_2.data:converge_1.data","points":[]},{"id":"patch_json_v3_2.patched:converge_1.converge","points":[]},{"id":"post_integration_url_v2_1.error:patch_json_v2_2.value","points":[]},{"id":"post_integration_url_v2_1.posted:patch_json_v3_2.patch","points":[]},{"id":"post_integration_url_v2_1.failed:patch_json_v2_2.patch","points":[]},{"id":"for_each_v2_1.item:data_relay_1.data","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":"google_sheets_update_table_rows_v2_1.updated:for_each_v2_1.next","points":[]},{"id":"google_sheets_fetch_table_rows_v3_1.rows:map_table_rows_1.rows","points":[]},{"id":"google_sheets_fetch_table_rows_v3_1.fetched:map_table_rows_1.map","points":[]},{"id":"google_sheets_fetch_table_row_mapping_1.mapping:map_table_rows_1.mapping","points":[]},{"id":"map_table_rows_1.mapped:filter_v2_1.filter","points":[]},{"id":"map_table_rows_1.mapped_rows:filter_v2_1.items","points":[]},{"id":"extract_v2_1.data:post_integration_url_v2_1.body","points":[]},{"id":"post_integration_url_v2_1.body:patch_json_v3_2.value","points":[]},{"id":"for_each_v2_1.done:stop_1.stop","points":[]}],"groups":{"group_1":{"title":"Fetch Rows","description":"","x":288,"y":294,"inputs":["google_sheets_fetch_table_row_mapping_1.fetch"],"outputs":["filter_v2_1.items","filter_v2_1.filtered","google_sheets_fetch_table_row_mapping_1.mapping","google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id"]},"group_2":{"title":"Update Sheet","description":"","x":1165,"y":269,"inputs":["patch_json_v3_2.value","unmap_table_rows_1.mapping","google_sheets_update_table_rows_v2_1.spreadsheet_id","data_relay_1.data","patch_json_v2_2.patch","patch_json_v2_2.value","patch_json_v3_2.patch"],"outputs":["google_sheets_update_table_rows_v2_1.updated"]},"group_3":{"title":"Create Pin","description":"","x":874,"y":290,"inputs":["extract_v2_1.data","extract_v2_1.extract"],"outputs":["post_integration_url_v2_1.body","post_integration_url_v2_1.error","post_integration_url_v2_1.failed","post_integration_url_v2_1.posted"]}},"widgets":{"widget_1":{"title":"Spreadsheet","description":"Select or enter id of the spreadsheet","position":0,"input":"google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id"},"widget_2":{"title":"Tab","description":"Select or enter the range in the selected spreadsheet in 'A1 notation'","position":0,"input":"google_sheets_select_spreadsheet_id_v2_1.range"}},"variables":{},"config":{"capture_inputs_enabled":false,"caching_enabled":false},"tags":[]}
  1. Create Ads from sheet: This automation allows you to create ads on Pinterest using the inputs in the sheet and the created pins. It updates the spreadsheet with the IDs of the created ads.
Bulk Ad Creation
{"name":"Bulk Ad Creation","description":"A blank recipe","nodes":{"start_1":{"type":"start","logging_enabled":false,"error_rules":[],"x":150,"y":50},"stop_1":{"type":"stop","logging_enabled":false,"error_rules":[],"x":842,"y":566},"for_each_v2_1":{"type":"for_each_v2","logging_enabled":false,"error_rules":[],"x":565,"y":261,"inputs":{"next":{"title":"next","description":"Starts the next iteration"},"start":{"title":"start","description":"Starts the first iteration"}}},"google_sheets_fetch_table_row_mapping_1":{"type":"google_sheets_fetch_table_row_mapping","logging_enabled":false,"error_rules":[],"x":487,"y":377,"group":"group_1"},"google_sheets_fetch_table_rows_v3_1":{"type":"google_sheets_fetch_table_rows_v3","logging_enabled":false,"error_rules":[],"x":808,"y":99,"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"}}},"google_sheets_select_spreadsheet_id_v2_1":{"type":"google_sheets_select_spreadsheet_id_v2","logging_enabled":false,"error_rules":[],"x":187,"y":200,"group":"group_1","inputs":{"spreadsheet_id":{"export_enabled":true},"range":{"export_enabled":true,"data":"ads"}}},"filter_v2_1":{"type":"filter_v2","logging_enabled":false,"error_rules":[],"x":1324,"y":357,"group":"group_1","inputs":{"filters":{"export_enabled":true,"data":[{"operator":"=","pointer":"/data/output/ad_action","value":"create"},{"operator":"=","pointer":"/data/output/ad_id","value":null}]}},"outputs":{"filtered":{"title":"filtered","description":"Triggered when the list was filtered"}}},"patch_json_v2_1":{"type":"patch_json_v2","logging_enabled":false,"error_rules":[],"x":1800,"y":153,"group":"group_2","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/0","value":"{{input.value}}"}]},"data":{"title":"data","description":"The data the patches are applied to","export_enabled":true,"data":[]}}},"patch_json_v3_1":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1529,"y":131,"group":"group_2","inputs":{"patches":{"export_enabled":true,"data":[{"op":"remove","path":"/data"},{"op":"add","path":"/data/output","value":"{{inputValue('')}}"},{"op":"add","path":"/data/config/status","value":""}]}},"outputs":{"patched":{"title":"patched","description":"Triggers when the patches were applied"}}},"unmap_table_rows_1":{"type":"unmap_table_rows","logging_enabled":false,"error_rules":[],"x":2104,"y":105,"group":"group_2","inputs":{"schema":{"export_enabled":true,"data":"any"}},"outputs":{"unmapped":{"title":"unmapped","description":"Triggered when mapped"}}},"google_sheets_update_table_rows_v2_1":{"type":"google_sheets_update_table_rows_v2","logging_enabled":false,"error_rules":[],"x":2414,"y":138,"group":"group_2","outputs":{"updated":{"title":"updated","description":"Triggered when the rows were updated"}}},"data_relay_1":{"type":"data_relay","logging_enabled":false,"error_rules":[],"x":1219,"y":16,"group":"group_2","inputs":{"data":{"title":"ad_row","description":"Data to relay"}}},"converge_1":{"type":"converge","logging_enabled":false,"error_rules":[],"x":1195,"y":230,"group":"group_2"},"patch_json_v2_2":{"type":"patch_json_v2","title":"if_error","description":"Apply JSON patches against data","logging_enabled":false,"max_job_retries":6,"timeout":30,"error_rules":[],"x":857,"y":390,"group":"group_2","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/error","value":"{{input.value/data/error/message}}"},{"op":"add","path":"/ad_action","value":"Error"}]},"value":{"title":"error","description":"A value that can be used in patches"},"data":{"export_enabled":true,"data":{}},"patch":{"title":"if_ad_error","description":"Starts the patching"}}},"patch_json_v3_2":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":849,"y":59,"group":"group_2","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/ad_id","value":"{{inputValue('/id')}}"},{"op":"add","path":"/ad_action","value":"done"}]},"data":{"export_enabled":true,"data":{}},"patch":{"title":"if_success","description":"Starts the patching"}},"outputs":{"data":{"title":"output","description":"The patched data"}}},"map_table_rows_1":{"type":"map_table_rows","logging_enabled":false,"error_rules":[],"x":1054,"y":376,"group":"group_1","inputs":{"schema":{"export_enabled":true,"data":"any"}}},"pinterest_select_ad_account_id_1":{"type":"pinterest_select_ad_account_id","logging_enabled":false,"error_rules":[],"x":233,"y":608,"inputs":{"ad_account_id":{"export_enabled":true}}},"pinterest_create_ad_1":{"type":"pinterest_create_ad","logging_enabled":false,"error_rules":[{"error_type":".*","expression":".*"}],"x":1256,"y":393,"group":"group_3"},"extract_v2_1":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":734,"y":398,"group":"group_3","inputs":{"default_value":{"export_enabled":true},"pointer":{"export_enabled":true,"data":"/data/ad"}}},"patch_json_v3_3":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1007,"y":398,"group":"group_3","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/creative_type","value":"REGULAR"},{"op":"cast","path":"/ad_group_id","value":"string"}]},"value":{"export_enabled":true}}}},"edges":[{"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.spreadsheet_id:google_sheets_fetch_table_row_mapping_1.spreadsheet_id","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_1.range:google_sheets_fetch_table_row_mapping_1.range","points":[]},{"id":"google_sheets_select_spreadsheet_id_v2_1.range:google_sheets_fetch_table_rows_v3_1.range","points":[]},{"id":"start_1.start:google_sheets_fetch_table_row_mapping_1.fetch","points":[]},{"id":"google_sheets_fetch_table_row_mapping_1.fetched:google_sheets_fetch_table_rows_v3_1.fetch","points":[]},{"id":"filter_v2_1.filtered:for_each_v2_1.start","points":[]},{"id":"filter_v2_1.items:for_each_v2_1.items","points":[]},{"id":"data_relay_1.data:patch_json_v3_1.data","points":[]},{"id":"patch_json_v3_1.data:patch_json_v2_1.value","points":[]},{"id":"patch_json_v3_1.patched:patch_json_v2_1.patch","points":[]},{"id":"patch_json_v2_1.patched:unmap_table_rows_1.unmap","points":[]},{"id":"patch_json_v2_1.data:unmap_table_rows_1.mapped_rows","points":[]},{"id":"unmap_table_rows_1.rows:google_sheets_update_table_rows_v2_1.rows","points":[]},{"id":"unmap_table_rows_1.unmapped:google_sheets_update_table_rows_v2_1.update","points":[]},{"id":"converge_1.converged:patch_json_v3_1.patch","points":[]},{"id":"converge_1.data:patch_json_v3_1.value","points":[]},{"id":"patch_json_v3_2.data:converge_1.data","points":[]},{"id":"patch_json_v2_2.patched:converge_1.converge","points":[]},{"id":"patch_json_v2_2.data:converge_1.data","points":[]},{"id":"patch_json_v3_2.patched:converge_1.converge","points":[]},{"id":"for_each_v2_1.item:data_relay_1.data","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":"google_sheets_update_table_rows_v2_1.updated:for_each_v2_1.next","points":[]},{"id":"google_sheets_fetch_table_rows_v3_1.rows:map_table_rows_1.rows","points":[]},{"id":"google_sheets_fetch_table_rows_v3_1.fetched:map_table_rows_1.map","points":[]},{"id":"google_sheets_fetch_table_row_mapping_1.mapping:map_table_rows_1.mapping","points":[]},{"id":"map_table_rows_1.mapped:filter_v2_1.filter","points":[]},{"id":"map_table_rows_1.mapped_rows:filter_v2_1.items","points":[]},{"id":"for_each_v2_1.done:stop_1.stop","points":[]},{"id":"pinterest_select_ad_account_id_1.ad_account_id:pinterest_create_ad_1.ad_account_id","points":[]},{"id":"for_each_v2_1.item:extract_v2_1.data","points":[]},{"id":"extract_v2_1.extracted:patch_json_v3_3.patch","points":[]},{"id":"extract_v2_1.data:patch_json_v3_3.data","points":[]},{"id":"patch_json_v3_3.patched:pinterest_create_ad_1.create","points":[]},{"id":"patch_json_v3_3.data:pinterest_create_ad_1.data","points":[]},{"id":"for_each_v2_1.do:extract_v2_1.extract","points":[]},{"id":"pinterest_create_ad_1.failed:patch_json_v2_2.patch","points":[]},{"id":"pinterest_create_ad_1.created:patch_json_v3_2.patch","points":[]},{"id":"pinterest_create_ad_1.error:patch_json_v2_2.value","points":[]},{"id":"pinterest_create_ad_1.ad_id:patch_json_v3_2.value","points":[]}],"groups":{"group_1":{"title":"Fetch Rows","description":"","x":288,"y":294,"inputs":["google_sheets_fetch_table_row_mapping_1.fetch"],"outputs":["filter_v2_1.items","filter_v2_1.filtered","google_sheets_fetch_table_row_mapping_1.mapping","google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id"]},"group_2":{"title":"Update Sheet","description":"","x":1165,"y":269,"inputs":["patch_json_v3_2.value","unmap_table_rows_1.mapping","google_sheets_update_table_rows_v2_1.spreadsheet_id","data_relay_1.data","patch_json_v2_2.patch","patch_json_v2_2.value","patch_json_v3_2.patch"],"outputs":["google_sheets_update_table_rows_v2_1.updated"]},"group_3":{"title":"Create Ad","description":"","x":871,"y":284,"inputs":["pinterest_create_ad_1.ad_account_id","extract_v2_1.data","extract_v2_1.extract"],"outputs":["pinterest_create_ad_1.created","pinterest_create_ad_1.failed","pinterest_create_ad_1.ad_id","pinterest_create_ad_1.error"]}},"widgets":{"widget_1":{"title":"Ad Account","description":"Select or enter the id of the ad account","position":0,"input":"pinterest_select_ad_account_id_1.ad_account_id"},"widget_2":{"title":"Spreadsheet","description":"Select or enter id of the spreadsheet","position":0,"input":"google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id"},"widget_3":{"title":"Tab","description":"Select or enter the range in the selected spreadsheet in 'A1 notation'","position":0,"input":"google_sheets_select_spreadsheet_id_v2_1.range"}},"variables":{},"config":{"capture_inputs_enabled":false,"caching_enabled":false},"tags":[]}

Spreadsheet Template

After, importing all relevant automations, create a copy of all required automations and duplicate this spreadsheet.

How to use the automations

Step 1: Export Boards

Export your boards with the “Export boards to sheet” recipe. Simply choose the spreadsheet template and the right tab where you want to export the board's IDs.

Notion image

Step 2: Export Ad Groups

Export the ad groups to the spreadsheet using this automation. Select the Ad Account you’d like to export the ad groups from and select the status of the ad groups you want to export (All or Active). Choose the spreadsheet (which should be the same one used for step 1) and select the tab within the spreadsheet where you want to store the ad group data. → adgroups.

Notion image

Step 3: Create Pins from Sheet

Use this automation to create pins that will then be used to create your ads through the automation. Before running the automation, fill out each mandatory field and change the “Create” column to create in the template spreadsheet (pins tab).

Now, with all data set correctly and available in the sheet, you can create pins.

Make sure to choose the correct Spreadsheet and Tab and hit “Run Automation”.

Notion image
Notion image

Step 4: Create Ads from Sheet

Use this automation to create ads. Before running the automation, fill out each mandatory field and input the pin ID’s you want to use. Change the “Create” column to “Create” in the template spreadsheet (ads tab).

Now, with all data set correctly and available in the sheet, you can create ads.

Make sure to choose the correct Ad Account, Spreadsheet, tab and hit “Run Automation”.

Notion image
Notion image
 

Connected FAQs

Did this answer your question?
😞
😐
🤩

Last updated on June 20, 2024