Get a weekly Pinterest trends brief in your inbox. The flow collects your latest pins, saves clean records in Airtable, and uses AI to suggest what to post next. It helps social and content teams plan smarter with less manual work.

Each week at 8 AM a schedule starts the run. The system calls the Pinterest API, tags each pin as Organic, and maps fields like title, link, id, description, and created date. Records are upserted into an Airtable base so duplicates do not appear and data stays clean. An AI agent reads the Airtable table and writes insights and new pin ideas. A second model turns that into a short report, then Gmail sends it to your marketing lead with a clear subject line.

You will need a Pinterest access token, an Airtable personal access token, an OpenAI API key, and a Gmail connection in n8n Cloud. Adjust the schedule and the Airtable base and table to match your setup. Teams usually cut reporting time from hours to minutes and get fresh ideas for weekly planning, standups, and content calendars. This is helpful for social managers who want quick wins without manual exports or spreadsheets.

• Weekly schedule at 8 AM that you can change to fit your team
• Pulls pins from the Pinterest API and includes the Authorization header
• Code step marks each record as Organic and formats fields for Airtable
• Upserts into Airtable to prevent duplicates and keep a clean dataset
• AI agent uses OpenAI and Airtable Tool to find trends and suggest new pins
• Summarization model creates a short, easy to read report
• Gmail sends the brief to your chosen inbox with a clear subject

• Reduce manual reporting from 2 hours to 5 minutes
• Automate 90% of weekly data pulls and emails
• Improve data accuracy by 80% with upserted records
• Connect Pinterest Airtable OpenAI and Gmail in one flow
• Handle 10 times more pins without extra work
• Deliver pin ideas before the workday starts

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Pinterest, Airtable, OpenAI and Gmail. See the Tools Required section above for links to create accounts with these services.
3. In the n8n credentials manager, create an OpenAI credential. Click Create new credential, choose OpenAI, paste your API key from your OpenAI account, and save.
4. Create an Airtable Personal Access Token with read and write access to your base. In n8n credentials, add Airtable Personal Access Token and paste the token. Name the credential clearly, then save.
5. Connect Gmail in n8n using Gmail OAuth2. Create new credential, sign in to the sending account, grant send permissions, and test the connection.
6. Open the HTTP Request node Pull List of Pinterest Pins From Account. In Headers, set Authorization to Bearer YOUR_PINTEREST_TOKEN. Save the node.
7. Open the Airtable node Create Record Within Pinterest Data Table. Select your Airtable credential, choose the correct base and table, and confirm field mappings for link, type, title, pin_id, created_at, and description. Keep operation as upsert.
8. Review the Code node Update Data Field To Include Organic. Keep the Organic label or change it to match how you segment Organic vs Ads.
9. Open the Pinterest Analysis AI Agent node. Make sure the OpenAI credential is selected and the Airtable Tool points to the same base and table so the agent can read your data.
10. Open the Pinterest Data Analysis Summary LLM node. Confirm the OpenAI model and prompt. Keep the concise summary prompt or adjust the tone to your brand.
11. Open the Gmail node. Set the To email address, confirm the subject Pinterest Trends & Suggestions, and leave the message to use the summarized text.
12. Adjust timing in the 8:00am Morning Scheduled Trigger. Set the hour and interval to match your reporting cadence.
13. Validation: Run the workflow once manually. Confirm new rows appear in Airtable, check the AI output in the execution log, and verify the summary email arrives in your inbox.
14. Troubleshooting: If Pinterest returns 401, fix the Authorization header and token scope. If Airtable is empty, confirm base and table IDs. If email does not send, check Gmail quotas and spam. If AI fails, verify your OpenAI key, model, and usage limits.