Hello everyone,
I’ve been brainstorming how to build up an efficient workflow for my company’s email notification system and struggling.
We are currently running online workshops where kids meet in private groups to play Dungeons & Dragons. The groups meet 1-2x a week. An hour before every group starts, I have Zapier send an email with everyone’s character sheets (as a Google Doc link), a chatroom for rolling dice, and a Zoom room.
I’ve been able to automate most of this process so Zapier can read the time, date, and Zoom location to paste into the email. Now though, I want to find a way to more efficiently link in each kid’s character sheet so I don’t have to paste every single kid’s name and every single character sheet by hand.
My initial instinct was to set up a Google Sheet with names in one column and links in the other. However, the only action that can read this information is “Get Many Spreadsheet Rows.” This action takes all the information from the spreadsheet and puts it into a single JSON array.
Now, I’m not sure how to take this information and paste it neatly into an email. Right now, it sends out like this:
Character Sheets:
Ellen,Ayoel Ironbloom,Ranger
“The Kitten”,Fighter,Whit,Ponder Willow,Warlock
Links are pasting together, there are no paragraph breaks, and there are no spaces between the commas. I’ve tried to format this information with Formatter by Zapier, but since the Google Sheet output is a single text array, most of the formatting functions don't work.
Does anyone know how I can format this text, or can anyone offer a better method of accomplishing the same goal of sending links and information from a single source?
EDIT: This post was edited by a moderator to remove personal information from the images. Please be careful not to share private information as this is a public Community