The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
A Google Apps Script automated workflow that transforms standard Google Form submissions into an interactive, multi-step financial approval process for managers and HR. By leveraging Google Sheets, Gmail API, and Google's HtmlService, this project eliminates manual spreadsheet tracking and allows managers to approve, deny, or dynamically adjust financial requests directly from their inbox. All communications and interfaces are dynamically localized in both English and Latvian.
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Challenges
View all
Related posts
Saved 2 Hours Monthly with AI‑Powered Growth Report
I was sick of the monthly copy‑paste grind, so I let n8n do the heavy lifting. A Schedule Trigger pulls the raw numbers from Google Sheets, then an HTTP Request sends them to Groq AI. The AI spits out a concise growth report, which I forward to Telegram and also write back into Sheets for records. The whole pipeline runs unattended and shaves about two hours off my month‑end routine. It feels good to finally let the tools work for me.
#n8n #automation #ScheduleTrigger #GoogleSheets
Follow for more: https://go.phonezait.de/
Does someone on your team lose a day or two building the sales report every week or month?
That was the starting point at Mokobara, the premium travel brand. Pulling sales across all their stores, checking returns, reconciling the numbers and emailing each manager took 1 to 2 days every cycle, with 8+ hours of that spent just reconciling.
I built them an automation on Make.com a few months ago. It has run on its own ever since, weekly and monthly:
Make pulls every sales record from BigQuery, 100K to 250K per cycle. That is too many for one request, so it reads them page by page and stitches them back together.
It calculates the numbers the team actually uses: net sales per store after returns and discounts, return rates and the change against the last period.
It builds a CSV with the full breakdown and a short email summary you can read in 60 seconds.
It reads a Google Sheet of store representatives and emails every one of them the report for their own store.
The result: the reporting problem is gone. The report went from 1 to 2 days of manual work to fully automatic, and the 8+ hours of reconciliation dropped to zero.
Two things I would do the same way again:
Calculate "net sales" in the automation, not in the warehouse. The business rule for what counts as a net sale is not what the raw data stores.
Send people their slice, not the whole report. One report for everyone gets skimmed by everyone.
The figures in the image are placeholders, the real ones stay with the client.
What report is your team still building by hand? Tell me where the data lives and I will tell you how I would automate it.
One of the projects that shaped the type of work I enjoy building today.
Back in 2017, I had the opportunity to help develop this interactive editorial experience for CNN on the opening of the Louvre Abu Dhabi. That was my first project with CNN.
Rather than presenting the story as a traditional article, we used animation, scrolling, photography and video to guide readers through the architecture, engineering and vision behind the museum.
It's this blend of storytelling, design and development that made me realise how powerful the web can be when interaction becomes part of the narrative.
It's also the kind of work I still love creating today, whether for publishers, agencies or brands looking to tell a story in a more engaging way.
#CreativeDevelopment #InteractiveStorytelling #Scrollytelling #WebDevelopment #FrontEnd #GSAP #EditorialDesign #DigitalExperience #CreativeCoding #MotionDesign
this looks incredible.