InDesign Script to create custom sized pages from data

Hi there,

Looking for some help writing a script for use in InDesign. I have very little knowledge on how to write a script for InDesign but love using them! So any help would be AWESOME!

Problem:

We receive Excel sheets from Media companies containing a list of sizes (i.e for billboards - 576x28,600x920,750x360...) to be created. Currently I create an InDesign document, add pages and manually change each page size to suite the list, create the layouts and output files.

To make exporting faster I use a script called ‘Export-named-pages’. “The script determines file names for each page from the content, and exports images or PDFs. The result is uniquely named files of each page.”

Script Solution:

I’m after a script for InDesign (currently running 18.3) that will either create a document with custom sized pages from the supplied data - OR - change a pages size depending on the information supplied. Potentially from an excel sheet with a column of sizes WxH - OR - from text on a page in InDesign (after a quick data merge of sizes from supplied data).

Hopefully I have explained my self well enough 😐

Thanks in advance for any help!