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
Stop manually splitting order line items in Google Sheets.
Our order export puts every SKU for an order into one cell, like “A249,A231,A238,A236,A232”. To get usable item-level data (one row per product, with name and price), someone had to split, look up, and copy-paste by hand.
So I automated it with a small Google Apps Script. It adds an “Add Items” menu to the sheet, and one click turns the Orders sheet into a clean Items sheet:
→ Splits the comma-separated SKUs
→ Looks up each product’s name and price from the Inventory sheet
→ Writes one row per item, keeping the order date, ID, state, country, and pin
→ Marks each order as “Done” so it never gets processed twice
A few design choices I’m happy with:
🔹 Inventory is loaded into a Map once. Lookups are instant, instead of searching the sheet for every SKU.
🔹 No half-processed orders. If any SKU in an order is missing from Inventory, the whole order is skipped and the status shows exactly which SKUs are the problem (“Missing SKU: A999”). Fix the inventory, run it again, and it picks up where it left off.
🔹 Bulk writes only. All rows and statuses are written in two operations instead of cell by cell, so it stays fast as the data grows.
🔹 Safe to re-run. Orders with an existing status are skipped, so there’s no risk of duplicates.
In my test run, 9 orders became 22 clean item rows in a couple of seconds, with no copy-paste and no typos.
The lesson: you don’t need a big system to remove a repetitive task. Sometimes 80 lines of Apps Script is enough to give someone back their Friday afternoon.
What’s the most tedious spreadsheet task you’ve automated? 👇
#GoogleSheets #GoogleAppsScript #Automation #Ecommerce #Productivity #NoCode #Spreadsheets
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
Related posts
Mobile dashboard sheet interaction for sales automation platform
From packed boxes to a shipment the client can track.
This TechFoundry IMS demo reuses box details, retrieves UPS rates, creates shipping labels, and keeps tracking connected to the client order. A practical example of the AI and automation workflows we build into business software.
Watch the client shipping demo:
https://www.youtube.com/watch?v=8ohniU08JAA
#AI #Automation #SoftwareDevelopment #Shipping
I like that the shipment stays tied to the client order instead of living in a separate carrier tab. When box details get edited after the UPS rate is retrieved, does the system re-quote before creating the label, or lock the original rate? I'd be curious how you handle that mismatch on the tracking side.
You need a strong starting point for a sales-tech brand without trying too hard.
A generic SaaS template won’t work in this case.
What you need are:
• Sales-focused product UI
• Personalized outreach with follow-up and reply intelligence
• Pricing, testimonials, FAQs, and integrations
• CMS for blog posts, feature pages, and case studies
• Clear paths to demos and trials
That’s how we designed Avina, our new Framer template.
Built for AI sales products, outbound automation tools, and sales-focused SaaS products.
Avina is designed around a real outbound sales journey.
So visitors understand quickly.
Check the link in the comment.
What I like here is the focus on the actual sales journey, not just the visual design. For AI sales tools, showing how outreach, follow-ups, and reply handling connect to real outcomes can make a big difference. Curious how you approached that in Avina?