Microsoft Excel and Zenrows Integration

Demonstration of how apps are integrated in WEXTL workflow builder[4]

Keep Microsoft Excel and Zenrows matched by integrating their events and actions. When developer tools events happen in Microsoft Excel, update the Zenrows automatically - without any line of code in visual workflow builder.

  • 3-day trial
  • Cancel anytime
  • Up to 10 minutes quick set up
  • GDPR
  • Data Encryption
  • 2FA
  • Local Data Region

Learn about Microsoft Excel and Zenrows

Detailed info you need to know about Microsoft Excel and Zenrows integrations in WEXTL. Explore which modules apps support and how you connect them.

  • Microsoft Excel

    • Developer Tools
    • 20 searches
    • 20 actions

    Read and write workbook data in Microsoft Excel.[5]

  • Zenrows

    • Developer Tools
    • 1 trigger
    • 27 searches
    • 24 actions

    Web scraping API with anti-bot bypass, crawling and batch jobs.[6]

How to connect Microsoft Excel to Zenrows

Set up your Microsoft Excel and Zenrows integration in 3 simple steps[2]. No coding required. Up to 10 minutes setup.

How does the integration between Microsoft Excel and Zenrows work in WEXTL?

WEXTL exposes actions and triggers for Microsoft Excel and Zenrows that help you connect apps and automate repetitive tasks[1]. A trigger is an event that happens, and an action is a step that performs when the event has occurred.

Zenrows triggersMicrosoft Excel actions

Zenrows modules

  • Watch Job Events Starts a workflow as soon as a batch job reports an event. The Event type, Occurred at time and Job id come with each one.
  • Add Tasks to a Batch Job Appends scraping tasks to a batch job. Turn on Last Batch to mark the final group of Tasks you are sending.
  • Cancel an HMAC Key Rotation Abandons the candidate key of an HMAC key rotation that was started for your webhook signing.
  • Capture a Screenshot Takes a screenshot of a web page and returns it as a file. Use Full Page for the whole length, Element Selector to shoot one element, and Format with JPEG Quality to tune the image.
  • Close a Batch Job Tells ZenRows that a batch job has received all its tasks, so processing can finish.
  • Convert a Page to PDF Renders the page at a URL as a document. Use Wait For to hold until an element has loaded, and Premium Proxy for protected sites.
  • Create a Batch Job Opens an asynchronous scraping job with a Name, Tasks and Zenrows Params. Set Type to Scheduled for repeat runs and Metadata to attach your own values.
  • Create an Input Upload Slot Prepares an upload location for a CSV of URLs, based on the URL Column that holds them. Describe the file with Has Header Row and Delimiter.
  • Delete a Batch Job Removes a batch job from ZenRows, with all its runs and results.
  • Delete a Batch Run Deletes a run from the history of a batch job.
  • Download Crawl Results Downloads the pages gathered by a crawl as a file for further processing.
  • Extract Page Data Pulls structured Products from a page at a URL. Choose an Extract Mode and use Fields to limit what is read.
  • Fetch a Page Scrapes a page through ZenRows and returns its Body. Use Response Type to convert the page, CSS Extractor to read chosen elements and JavaScript Instructions to click or scroll before reading.
  • Fetch a Page With POST Reaches a page that expects a request Body and returns what the site answers. Use Premium Proxy to route the request through residential IPs.
  • Fetch a Page With PUT Loads a page through ZenRows with a Body in the request. Use Wait to pause after load and Custom Headers to forward your own headers to the target site.
  • Finalize an HMAC Key Rotation Makes the candidate key the active signing key for your webhooks.
  • Get a Batch Job Reads the setup of a batch job, including its Type, Status and Format.
  • Get a Batch Run Reads one run of a batch job and reports Status, Trigger and Stats.
  • Get a Crawl Reads a crawl with its Status, Depth and the Include patterns it follows. Use Cursor to continue from where a previous read stopped.
  • Get a Crawl Page Fetches the stored content of one page found by a crawl, using the Content ID of that page. Turn on Download as File to save it.
  • Get a Domain Preparation Status Checks how far preparation of a Domain has got, reporting its Status, State and any Failure.
  • Get a Job Webhook Reads the webhook attached to a batch job, giving its URL and Signature.
  • Get a Preparation Allowance Shows how many domain preparations you have Used and how many are Remaining this Month.
  • Get a Results Export Checks an export of run results by its Export ID. Once ready it has a Download url that stays valid until Expires at.
  • Get Latest Run Results Pulls the task results of the newest run of a batch job. Use Status to keep only successful or failed tasks, and Limit to stop at a fixed count.
  • Get Latest Task Content Fetches what one task scraped in the newest run. Turn on Download as File to get a file.
  • Get Latest Task History Shows the Events logged for a task during the newest run.
  • Get Plan Usage Shows where your ZenRows subscription stands in the current period, including the Credit limit.
  • Get Run Results Shows what each task produced in one chosen run of a batch job, with its URL and Status. Set Limit for the number of tasks listed.
  • Get Run Task Content Reads the scraped output of a task within a chosen run, as text or as a file when Download as File is on.
  • Get Run Task History Returns the log entries of a task within one chosen run.
  • List Batch Jobs Returns batch jobs from your account. Use Status to see open, closed or deleted ones, and Type to separate regular from scheduled.
  • List Batch Runs Shows each run a batch job has gone through, with its Run sequence and Status.
  • List Crawls Shows the crawls you have started, giving their URL, Status and Depth.
  • List Extract Domains Finds the domains that the extractor supports, with their Verticals and whether each is Warm.
  • List HMAC Keys Retrieves the Active key and the Candidate key used to sign webhooks.
  • List Prepared Domains Finds the domains you asked ZenRows to prepare, with their Status, State and Roles.
  • Make an API Call Sends a free-form request to the Zenrows REST API, signed with your saved credential.
  • Pause a Batch Run Pauses the current run of a batch job until you resume it.
  • Remove a Job Webhook Removes the notification webhook attached to a batch job.
  • Request a Domain Preparation Asks ZenRows to get a Domain ready for extraction. Add Example URLs to show the page layout.
  • Rerun a Batch Job Starts a new run of a batch job. Use Statuses to Retry to repeat only tasks with those outcomes.
  • Resume a Batch Run Continues a paused run of a batch job where it stopped.
  • Send a Test Webhook Posts a sample event to a URL to check that your endpoint answers. Turn on Sign Webhook to include a signature, and the result reports Delivered.
  • Set a Batch Schedule Gives a batch job a timetable with Schedule, as a set time, an interval or a calendar. Use Timezone to run it in a zone such as Europe/Berlin.
  • Set a Batch Schedule State Switches the timetable of a batch job between Active and Paused.
  • Set a Job Webhook Attaches a webhook URL to a batch job so ZenRows reports its events there. Turn on Sign Webhook to receive a Signature.
  • Start a Crawl Starts crawling a site from its URL. Use Depth to bound how far links are followed and Include Patterns to restrict which ones.
  • Start a Results Export Begins an export of run results into a downloadable file, and gives its Export ID.
  • Start an HMAC Key Rotation Creates a candidate key for signing webhooks and gives its Kid and Secret.

Microsoft Excel modules

  • Add a Table Column Creates one more column in an Excel table of the workbook. Output includes the column ID, Name, Index and Values.
  • Add a Table Row Adds a row to a table of the workbook. The new Index and its cell Values are in the output.
  • Apply a Table Sort Sorts an Excel table by a list of conditions. Use Fields to set the sort conditions, turn on Match Case to let letter casing affect string ordering, and use Method to set the ordering for Chinese characters.
  • Clear a Table Sort Clears the sort that is currently applied to a table in your workbook.
  • Close a Workbook Session Closes a workbook session that was opened with Create a Workbook Session in your Excel file.
  • Create a Table Turns a block of cells into an Excel table. Give the Address of the range, and use Has Headers when the data already has column labels. Output includes the new table Name and Style.
  • Create a Workbook Session Opens a session on the workbook. Turn on Persist Changes to save the changes made during the session, or leave it off for a session that does not save them.
  • Create a Worksheet Adds a sheet to the workbook under a unique Worksheet Name. Output includes its Position and Visibility.
  • Create a Worksheet Table Builds a table on one worksheet over a range. Use Address to mark the cells and Has Headers if the range has column labels. Output includes the ID, Name, Show headers, Show totals and Style of the new table.
  • Delete a Table Deletes a table object in the workbook, picked by its ID or name.
  • Delete a Table Column Removes a single column from your table, identified by Column ID.
  • Delete a Table Row Deletes the row at a given Index from an Excel table in the workbook.
  • Delete a Worksheet Removes a worksheet from the workbook by its ID or name.
  • List Table Columns Lists every column of a table. Use Limit to stop after a number of columns.
  • List Table Rows Lists every row in a table. Set Limit to read only the first rows.
  • List Tables Shows all tables in the workbook along with display flags such as Show banded rows and Show filter button. Set Limit to read fewer tables.
  • List Worksheet Names Gathers the named items defined on one worksheet. Output has each Comment, Scope and Type. Use Limit to cap the amount.
  • List Worksheet Tables Returns only the tables sitting on one worksheet, each with its Style. A Limit trims the result.
  • List Worksheets Finds the sheets of the workbook and emits one item for each. Use Limit to read fewer sheets.
  • Make an API Call Runs a free-form request against the Microsoft Excel REST API using your saved credential.
  • Re-Apply a Table Sort Runs the existing sort of a table again. The output repeats the Fields, Match case and Method in force.
  • Refresh a Workbook Session Refreshes a workbook session that is already open, keeping the same session in use.
  • Retrieve a Header Row Range Shows the header row range of one table column, with its Address and Cell count.
  • Retrieve a Table Looks up a single Excel table. The result shows its Style and whether headers and totals are visible through Show headers and Show totals.
  • Retrieve a Table Column Gets a table column by Column ID. The Values of that column are included.
  • Retrieve a Table Column Body Range Returns the data body range of a table column. Output includes Column count and Value types for what the range holds.
  • Retrieve a Table Column Item Fetches a table column by Column Index. Output includes its ID, Name and Values.
  • Retrieve a Table Column Range Returns the full range of a table column, along with its Address and Column index.
  • Retrieve a Table Row Reads one table row by its Index and outputs its cell Values.
  • Retrieve a Table Row Item Pulls the table row sitting at an Index. Its cell Values are in the output.
  • Retrieve a Table Row Range Finds the cell range of the table row at an Index and reports its Address, Column index and Value types.
  • Retrieve a Table Sort Shows how a table is currently sorted, including the sort Fields, the Match case setting and the Method used for Chinese characters.
  • Retrieve a Total Row Range Gives the total row range for one table column, showing its Column index and Value types.
  • Retrieve a Worksheet Gets a single worksheet by ID or name. The sheet is returned with its Position and Visibility.
  • Retrieve a Worksheet Cell Reads a worksheet cell. Set Row and Column as zero-based numbers. The output shows its Address and Value types.
  • Retrieve a Worksheet Range Takes the range of a worksheet and returns Address local and Cell count.
  • Update a Table Renames a table with Table Name and applies a Table Style. Switch the header row with Show Headers or the total row with Show Totals.
  • Update a Table Column Modifies a table column found by Column ID. The result includes its Name, Index and Values.
  • Update a Table Row Changes a table row located by Index. The result shows the Index and Values of that row.
  • Update a Worksheet Renames a worksheet through Name and moves it with Position. Use Visibility to hide or show it.

Explore alternative integrations

There are other apps[9] supported by WEXTL that can be paired with Microsoft Excel and Zenrows integrations. Pick any from the list below if the current combination isn't the one you need.

Automate Microsoft Excel and Zenrows on WEXTL®

Claim your 3-day trial to build Microsoft Excel with Zenrows integration and access every WEXTL® feature.

Cancel anytime.

Frequently asked questions

Common questions about connecting Microsoft Excel and Zenrows.

How do I connect Microsoft Excel and Zenrows?

Connect your Microsoft Excel and Zenrows accounts once, pick a trigger in one app and an action in the other, then map the fields so data flows automatically between them.[3]

What can I automate between Microsoft Excel and Zenrows?

Example: when the "Watch Job Events" trigger in Zenrows fires, WEXTL can "Add a Table Column" in Microsoft Excel. Microsoft Excel has 40 actions (including Add a Table Column, Add a Table Row, and Apply a Table Sort). Zenrows has 51 actions (including Add Tasks to a Batch Job, Cancel an HMAC Key Rotation, and Capture a Screenshot). Add filters and transforms between steps when you need them.[1]

Can Microsoft Excel trigger actions in Zenrows, and Zenrows in Microsoft Excel?

Yes. The integration works in both directions. Use the triggers of each app to start a workflow and the actions of the other app to update it.[2]

Do I need to write code to integrate Microsoft Excel and Zenrows?

No. Microsoft Excel-to-Zenrows automations are built visually on the canvas. You can optionally add custom JavaScript with Functions when you need advanced logic.[4]

Does Microsoft Excel integrate with Zenrows in real time?

Yes. Trigger-based automations start the moment Microsoft Excel (or Zenrows) fires a new event. Webhook-backed apps run within seconds, and polling-only apps re-check on a schedule you control.[7]

How long does it take to set up a Microsoft Excel + Zenrows integration?

A first automation typically takes 5–10 minutes: connect the credential of each app once, drop a trigger + action onto the canvas, map the fields, and turn the workflow on.

Do I need a paid plan to connect Microsoft Excel with Zenrows?

You can build your Microsoft Excel + Zenrows automation on a 3-day trial with every feature unlocked. Cancel anytime.[8]

References

List of sources used to gather information about the Microsoft Excel and Zenrows integration.

  1. Microsoft Excel and Zenrows integration source code, module specs and credentials implementation.
  2. Our Microsoft Excel and Zenrows integration documentation, structured input and output parameters, scopes, and authentication methods.
  3. Official vendor API documentation for Microsoft Excel and Zenrows, used to verify field meanings, authentication flows, and anything our own specs don't fully capture.
  4. WEXTL® visual workflow builder, anonymized data from our technical support team.
  5. Microsoft Excel integration information
  6. Zenrows integration information
  7. WEXTL® Scheduling
  8. WEXTL® Pricing and Trial
  9. WEXTL® Apps Library

How we write our apps documentation

Explore how WEXTL® crafted Microsoft Excel and Zenrows integration page documentation. Used sources, the role of AI, and how the team validates the result.

Explore Microsoft Excel and Zenrows, or get started