Automation Blocks - Modify Update Texts of Ae Mogrt to recognize column name, not number

Forum|Forum|7 months ago
September 1, 2025
2 replies
134 views

I'm crafting a variation of the Update Texts of Ae Mogrt with Spreadsheet script (another upskilling from my current knowledge base given the way it works).

I want the target coumn index to be dynamic, and dependent on other data in the project (potentially sequence name).

To start that process, I'm hoping you can answer this first question - can the variable "target column index" be tied to the text in row 1 of the spreadsheet, as opposed to just the column number? Example - Cell 1B is titled "this column" and we've defined the variable "target column index" as "this column"

SDK

Mathias Moehl

Community Expert

Not sure if I fully understood your issue. But if you want to read the target column index from the spreadsheet itself, you could do it like this:

Mathias Möhl - Developer of tools like BeatEdit and Automation Blocks for Premiere Pro and After Effects

C

Citizen_SamAuthor

Inspiring

I actually figured out a way to do it (sort of)!
I wrapped all the blocks below the "set my row" variable block into an If/Do block...
If name of sequence = get cell of spreadsheet file in row my row and column target column index

So it only completes the script of the sequence name matches the target cell.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded