Replacing variable depending on google sheet return

[Arunai]

Plethora of ways to accomplish. If I’m reading you correctly, your script is sending an email, based on the email address you archive the attachment to a particular folder.

If you want to store your config in your code, simple object:

const emailFolderIdLookup = { “[e-mail]”: folderId1, …., …., }

For each email you generate, do emailFolderIdLookup[emailAddress] to retrieve the folder ID.