SERP Analysis with OpenAI and Google Sheets Reporting

## Workflow Instructions
#### Requirements
To use this workflow, you will need accounts and API access for the following services:
- **Google Sheets**
- **Serper Dev**
- **OpenAI**
#### Google Spreadsheet Setup
Create a Google Spreadsheet with **three sheets** named exactly as follows:
1. **SERP Analysis**  
   Columns (in order):  
   `position`, `title`, `link`, `snippet`, `short_summary`, `potential_focus_keyword`, `relevant_long_tail_keywords`, `unigrams`, `bigrams`, `trigrams`
2. **FAQs**  
   Columns (in order):  
   `question`, `title`, `link`, `snippet`
3. **Related Searches**  
   Columns (in order):  
   `query`
> **Tip:** Make sure the sheet names and column headers match exactly, including capitalization and spacing, to ensure the workflow functions correctly.
#### Getting Started
1. **Set up your Google Spreadsheet** as described above.
2. **Configure your API credentials** for Serper and OpenAI within n8n.
3. **Import the workflow** into your n8n instance.
4. **Update any required variables or nodes** in the workflow to point to your specific spreadsheet and API keys.
5. **Run the workflow** and monitor the results in your Google Sheets.
#### Support & Contact
Developed by **Marvomatic**
- [Website](https://marvomatic.com)
- [TikTok](https://www.tiktok.com/@marvomatic)
- [YouTube](https://www.youtube.com/@marvomatic)

For business inquiries, email: [hello@marvomatic.com](mailto:hello@marvomatic.com)