What are you trying to achieve?
I’m a digital marketer for a company with several stores, and I have a google sheet document where I keep track of all the digital campaigns and ad spends for each store, each month.
I want to automate the email that I send every month to my accountant that has the same format and where I enter each value from the spreadsheet manually.
Steps taken so far
I’m almost there as I managed to get a document that almost looks identical to the email I sent every month. Except for two things :
A store can have several campaigns in a month, but not use the same ad platforms.
In my email, I want it to look that way :
Store #1
Name of campaign #1
Amount spent on facebook : XXX €
Amount spent on Google : XXX €
Name of campaign #2
Amount spent on Google : XXX €
Store #2
Name of campaign #1
Amount spent on facebook : XXX €
Amount spent on Google : XXX €
But with my current scenario I get this result :
Chicago Store
Easter Campaign
Amount spent on facebook : XXX €
Amount spent on Google : XXX €
Chicago Store
Christmas Campaign
Amount spent on Google : XXX €
New York Store
Easter Campaign
Amount spent on facebook : XXX €
Amount spent on Google : XXX €
What can I do to get my Easter and my Christmas Campaign together under “Chicago Store” instead of having the name of the store twice ?
Moreover, I use if conditions to display each line :
If Amount spent on Facebook > 0; Amount Spent of Facebook : XXX €; “”
If Amount spent on Google > 0; Amount Spent of Google : XXX €; “”
The conditions work, but on my final document (I’m sending it to google doc for my test instead of an email) lines are jumped instead of just not being displayed. So I end up with a lot of white space.
I’m french so I hope my message was correct. I’ll include as many screenshots as I can to help you understand my problems.
On the final screenshot (from google doc) :
“Piscines Ibiza Béziers - DMP 34” = Chicago Store in my example
“Robots Days 2025” = Campaign #1
“Drive to Store” = Campaign #2
And the red scribble shows the empty lines because I only have Google Ads for this campaign, and not the other 3 channels.
Thank you in advance for your help
