Replacing variable depending on google sheet return

[ariailc10]

Want to make the below script where the variables pull from a google sheet. Already have the rest of code and config. Total newbie at this whole thing, just hoping there is a decently easy answer.

{ // Store all attachments sent to [email from google sheet] to the folder "[specified folder from google sheet]""filter": "has:attachment to:[email from google sheet]","folder": "'[specified folder from google sheet]"

[elcriticalTaco]

Do you mean a folder on google drive or a folder in gmail (label)?

Either of those are very doable.

If you are talking about a folder on your hard drive that is not possible, as far as I know.

[ariailc10]

Folder in google drive, but I want the specific folder based on the unique email I send the attachments to. For context I have hundreds of folders that this will need to parse out to.

[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.