Wayfair / Extern Project · Market intelligence automation
Competitor research automation
I used n8n and Gemini to help collect competitor information and update a shared research sheet. I summarized rug market trends in reports, visual reference boards, and a presentation.
01 · The business question
Market intelligence automation project completed through Wayfair/Extern.
How can repeated competitor research become an organized input for reviewing market trends?
02 · My contribution
- Automated competitor monitoring and Google Sheets updates using n8n and Gemini agents.
- Summarized rug market trends in reports and visual reference boards.
- Presented the research in Google Slides.
03 · The finding
The project brought recurring research into a shared format that could be reviewed through reports, visual references, and a presentation.
Project overview
Competitor research: from sources to report
An organized research sheet, market trend reports, visual reference boards, and a presentation.
A diagram of the Wayfair / Extern research project. No measured time savings are claimed.
Wayfair / Extern research project
Public competitor information
Shared research in Google Sheets
Research outputs
- Trend reports
- Visual reference boards
- Presentation
A summary of the research workflow. It does not represent measured time savings.
04 · The decision
Use the organized research to support a discussion about market trends. The related method example adds a proposed step for checking sources and recording a reviewer’s decision.
Related workflow sample05 · Work delivered
- n8n and Gemini research workflow
- Google Sheets updates
- Rug market reports and moodboards
- Google Slides presentation
Learning notes
Collecting research is only part of the workflow.
- A useful research record keeps the observation connected to its source. Summaries are easier to review when they share a consistent structure.
- Reports and moodboards need interpretation before they become a recommendation. An automated collection step does not remove that review.
A next questionEvaluate source coverage and summary accuracy, and record exceptions before expanding a recurring research workflow.
Terms explained
- Workflow automation
- Connecting steps so that a tool performs some of the repeated work.
- n8n and Gemini
- n8n connects workflow steps. Gemini provides AI assistance with tasks such as summarizing research.
- Moodboard
- A collection of visual references used to discuss a style or trend.
Context & measurement notes
A Wayfair/Extern project focused on research automation, reports, moodboards, and a presentation.
Related work samples
Check the method.
Separate examples with their source data and assumptions.