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.
- 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
.
{"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":[]}
- 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
.
{"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":[]}
- 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.
{"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":[]}
- 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.
{"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.
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
.
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”.
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”.
Connected FAQs
Last updated on June 20, 2024