{"id":"pageworkers_push_items_to_optimization","name":"Push items to a PageWorkers optimization","alias":"PageworkersPushItemsToOptimization","aliases":[],"description_short":"Run a SQL query, generate a CSV, and upload it to a PageWorkers optimization via the Activation API.","description_long":"\n    This agent executes a BigQuery SQL query, converts the results into a CSV file,\n    obtains a signed upload URL from the Activation API, and uploads the CSV to the\n    optimization module's dataset.\n    Always prefix tables with \"catalog.\" (e.g. catalog.crawl_pages_20251201).\n    ","description_tool_prompt":"\n    Push items to a PageWorkers optimization. Runs a SQL query, generates a CSV from the results,\n    and uploads it to the specified optimization module.\n    ","source":"Botify","conversation_examples":["Push SQL query results as CSV to PageWorkers optimization module XYZ","Upload data from a SQL query to the optimization dataset"],"tags":["collaboration"],"available_in_chat":false,"available_in_deepthink":false,"available_in_mcp":true,"mcp_audience":"all","config":{"type":"object","properties":{},"required":[]},"item":{"type":"object","properties":{"module_id":{"description":"The stable ID of the PageWorkers optimization module to push items to","title":"Module Id","type":"string"},"query":{"description":"BigQuery SQL query whose results will be exported as CSV and uploaded to the optimization. Prefix tables with \"catalog.\" (e.g. catalog.crawl_pages_20251201).","title":"Query","type":"string"}},"required":["module_id","query"]},"response":{"description":"Output of the PageWorkers push-items-to-optimization agent.","properties":{"websiteId":{"description":"The website ID","title":"Websiteid","type":"string"},"module_id":{"description":"The optimization module stable ID","title":"Module Id","type":"string"},"filename":{"description":"The filename of the uploaded CSV","title":"Filename","type":"string"},"row_count":{"description":"Number of rows exported and uploaded","title":"Row Count","type":"integer"},"message":{"description":"Message about the operation","title":"Message","type":"string"}},"required":["websiteId","module_id","filename","row_count","message"],"title":"PageworkersPushItemsProcessedItem","type":"object"},"has_canvas":false,"open_canvas_automatically":false}