Back to Apify in Excel
SheetXAI logo
Apify logo
Apify · Excel Guide

Audit Apify Actor Task Configurations From a Google Sheet

2026-05-14
5 min read

The Scenario

You're a developer managing 25 Apify Actor tasks that a previous team member set up over the past two years. You've been asked to audit which tasks still use deprecated input settings before Apify sunsets the old schema version next month. The list of tasks exists somewhere in the Apify console. The input configuration for each one is buried three clicks deep.

You found out about the deprecation from a release note you happened to catch last Thursday. Nobody flagged it to you. The deadline is in 11 days.

The bad version:

  • Open the Apify console, click into each of the 25 tasks one by one, navigate to the Input tab, take note of the schema version and any flagged fields, go back to the task list, and repeat.
  • Copy the relevant fields into your workbook manually — task name, Actor ID, task ID, creation date, and the input JSON — for all 25 tasks, formatted consistently enough to be useful.
  • Spend an afternoon comparing each input JSON against the deprecation checklist, marking which tasks need to be updated, then write up a remediation plan nobody asked you to write.

11 days is not much runway if half of them need to be updated.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook, understands what you need, and through its built-in Apify integration it can list all your Actor tasks, fetch their metadata, and write the configuration details into the workbook for bulk review.

List all my Apify Actor tasks and write task name, Actor ID, task ID, and creation date into columns A–D

What You Get

  • Column A contains the task name for each of your 25 tasks.
  • Column B contains the associated Actor ID.
  • Column C contains the task ID.
  • Column D contains the creation date formatted as a readable string.
  • Rows are sorted by creation date ascending so the oldest tasks appear first.

What If the Data Is Not Quite Ready

You also need the input configuration for each task, as a JSON string, to review in bulk

Fetch the input configuration for each task in column C (task IDs) and paste it as a JSON string into column E so I can review settings in bulk

You want to flag tasks where the input JSON contains the deprecated field 'useApifyProxy'

List all my Apify Actor tasks, write task name, Actor ID, task ID, and creation date into columns A–D, then fetch each task's input JSON and write it into column E; highlight column E in yellow for any task whose input contains the string 'useApifyProxy'

You only want tasks associated with a specific Actor ID

List all my Apify Actor tasks where the Actor ID matches 'apify/web-scraper', write task name, task ID, creation date, and input JSON into columns A–D

You want the full audit sweep in one prompt

List all my Apify Actor tasks, write task name, Actor ID, task ID, creation date, and input JSON into columns A–E; highlight any row in red where the input JSON contains 'useApifyProxy' or 'crawlerType'; then write a count of flagged tasks into cell G1 with the label 'Needs Update'

Everything you need for the remediation review, without spending a morning clicking through the console.

Try It

Get the 7-day free trial of SheetXAI and open a blank Excel workbook, then ask it to pull all your Apify task configurations so you can audit them in one place. You can also explore how to build an Actor status dashboard or read the Apify integration overview.

Stop memorizing formulas.
Tell your spreadsheet what to do.

Join 4,000+ professionals saving hours every week with SheetXAI.

Learn more