Workarounds for the 500 google sheet lookup limit without having to separate sheets

My pleasure ​@SamB 

// Retrieve input variables from the "input" object; default to empty arrays if undefined

let gsheetEmails1 = input.gsheetEmails1 || [];

let gsheetEmails2 = input.gsheetEmails2 || [];

let gsheetEmails3 = input.gsheetEmails3 || [];

let gsheetLocations1 = input.gsheetLocations1 || [];

let gsheetLocations2 = input.gsheetLocations2 || [];

let gsheetLocations3 = input.gsheetLocations3 || [];

// Ensure each input is an array (if not, wrap it in an array)

gsheetEmails1 = Array.isArray(gsheetEmails1) ? gsheetEmails1 : [gsheetEmails1];

gsheetEmails2 = Array.isArray(gsheetEmails2) ? gsheetEmails2 : [gsheetEmails2];

gsheetEmails3 = Array.isArray(gsheetEmails3) ? gsheetEmails3 : [gsheetEmails3];

gsheetLocations1 = Array.isArray(gsheetLocations1) ? gsheetLocations1 : [gsheetLocations1];

gsheetLocations2 = Array.isArray(gsheetLocations2) ? gsheetLocations2 : [gsheetLocations2];

gsheetLocations3 = Array.isArray(gsheetLocations3) ? gsheetLocations3 : [gsheetLocations3];

// Merge the arrays and filter out any falsey values (like empty strings or null)

let agentEmails = [...gsheetEmails1, ...gsheetEmails2, ...gsheetEmails3].filter(Boolean);

let agentLocations = [...gsheetLocations1, ...gsheetLocations2, ...gsheetLocations3].filter(Boolean);

// Convert each array to a string, with each item on its own line and ending in "[:space:]"

let agentEmailsLineItems = agentEmails.map(email => `${email} [:space:]`).join('\n');

let agentLocationsLineItems = agentLocations.map(location => `${location} [:space:]`).join('\n');

// Return the final text

return {

agentEmails: agentEmailsLineItems,

agentLocations: agentLocationsLineItems

};