My contribution
Connected competitor monitoring and AI assisted research with structured reporting and a presentation.
← All work
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.
n8nworkflow automation
GeminiAI agents
Sheetsresearch reporting
Project overview
Turn scattered market information into a research report
Work produced
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
n8n+Gemini
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.
Project overview
Market intelligence automation project completed through Wayfair/Extern.
Methods
Workflow design, research synthesis, and communication.
Purpose
Helps a team organize recurring market information for a focused review.
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.
01 · The business question
How can repeated competitor research become an organized input for reviewing market trends?
02 · My contribution
- Connected competitor monitoring with updates to Google Sheets using n8n, a tool for linking steps in a workflow, and Gemini, an AI tool.
- Summarized rug market trends in reports and moodboards, which collect visual references in one place.
- 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.
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.
View the related workflow sample ↗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.
05 · Work delivered
- n8n and Gemini research workflow
- Google Sheets updates
- Rug market reports and moodboards
- Google Slides presentation
See the method up close
Related methods.
Working examples with their data and assumptions.
Explore related fields
Follow the methods across other projects and working examples.
Context & measurement notes
A Wayfair/Extern project focused on research automation, reports, moodboards, and a presentation.