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
ā¢ 1d
Automated Shopify P&L in Google Sheets
Built a reporting workflow that brings Shopify sales data, Meta Ads spend, and COGS into one automated Google Sheets P&L.
The workflow:
šļø Shopify API ā Sales, orders, refunds & product data
š£ Meta Ads API ā Advertising spend & campaign data
š Google Drive ā COGS file uploads
āļø Google Sheets + Apps Script ā Data cleaning, calculations & reporting
The final P&L can track:
ā¢ Revenue
ā¢ COGS
ā¢ Gross Profit & Margin
ā¢ Ad Spend
ā¢ Net Profit
ā¢ Product-level profitability
The goal is simple: reduce manual reporting and give the business a clearer view of actual profitability.
Built by Skillytics Consulting for practical ecommerce analytics and automation.
#Shopify #GoogleSheets #AppsScript #EcommerceAnalytics #PAndL #BusinessAutomation #DataAnalytics
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
AURA ā Luxury Fragrance Website šøāØ
AURA is a luxury fragrance website concept built around softness, atmosphere, and product storytelling.
The goal was to make the perfume feel almost weightless ā combining dreamy skies, delicate pastel tones, translucent UI elements, and an oversized product visual to create an emotional first impression.
Special attention was given to:
ā¢ a product-focused hero that makes the fragrance the main visual anchor
ā¢ soft glassmorphism cards for fragrance notes, pricing, and product details
ā¢ an airy pastel palette inspired by clouds, light, and floral notes
ā¢ elegant typography that adds a premium editorial feel
ā¢ a fragrance selector that introduces different scents without distracting from the hero
ā¢ clear product discovery and shopping actions
ā¢ a mobile experience that keeps the same immersive visual atmosphere
ā¢ a lightweight mobile menu with product discovery and social touchpoints
The result is a soft, premium digital experience that combines luxury storytelling with clear e-commerce functionality.
Looking to create a distinctive website for your beauty, fragrance, or lifestyle brand? Letās create something memorable āØ
The typography fits the fragrance vibe perfectly š·
I redesigned this mobile offer section of product page on @Figma to create a clearer, more persuasive buying experience.
The original page presented the essential information, but the benefits, product options and purchase controls were difficult to scan.
For the redesign, I improved:
ā¢ Product and offer hierarchy
ā¢ Benefit-focused messaging
ā¢ Product gallery and visual presentation
ā¢ Flavour and bundle selection
ā¢ Pricing and savings visibility
ā¢ Trust signals near the CTA
ā¢ Mobile usability and buying flow
The goal was to help shoppers understand the product, compare their options and move toward purchase with less friction.
This is a concept redesign created to demonstrate my approach to conversion-focused Shopify product page design.
Good hierarchy fix, the before version buries the flavor picker and quantity discount below a wall of bullet points. On the bundle tiers, are the 10/20/30% discounts pulled from a real margin model for a shake product, or placeholder numbers for the concept? That third tier...
A 6-month MIS dashboard tracking revenue, expenses, net profit and margin trends with an auto-updating bar chart, giving founders a one-page view of business health.
