How to Automate Gmail Pinterest Trends Reporting?
Description
Get a weekly Pinterest trends report sent to your inbox. The flow collects fresh pins, stores the data in Airtable, studies the results with AI, and emails a short summary with new post ideas. It fits teams that plan content and want quick insight without manual work.
Every week at 8 am a schedule kicks off. The flow calls the Pinterest API to pull pins. A code step tags the data as Organic and formats fields like link, title, description, and created date. Records are upserted into an Airtable table, so duplicates are not added. An AI agent reads the table through the Airtable tool and an OpenAI model to spot trends and list pin ideas that match your audience. A summary model condenses the findings into clear notes. Gmail then sends the insights with the subject Pinterest Trends and Suggestions. You can change the run time and the recipient at any time.
Setup needs a Pinterest access token, an Airtable base and table, an OpenAI key, and a Gmail account. Map fields so pin_id is the unique value and add the Authorization header for the Pinterest call. Expect reporting time to drop from hours to minutes and get steady content ideas you can act on. This is helpful for social media managers, small brands, and agencies that report on Pinterest.
Tools Required
What this workflow does?
- Weekly schedule runs at 8 am to start the data pull
- HTTP request fetches pins from the Pinterest API
- Code step tags each record as Organic and formats fields
- Airtable upsert writes link, title, type, pin_id, description, and created date
- AI agent reads the Airtable table and finds trends and new pin ideas
- Summary model creates a short, clear briefing for managers
- Gmail sends the report with a preset subject and message body
- Configurable run time and recipient to fit team schedules
What are the benefits?
- Reduce weekly reporting work from 2 hours to 10 minutes
- Automate 100 percent of pin collection and email delivery
- Improve data quality by removing copy paste errors
- Unify Pinterest and Airtable data in one place
- Scale to handle many more pins without extra effort
How to set this up?
- 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.
- You'll need accounts with Pinterest, Airtable, Gmail and OpenAI. See the Tools Required section above for links to create accounts with these services.
- In the n8n credentials manager, connect Airtable: create a new Airtable Personal Access Token on the Airtable website, then create a new credential in n8n and paste the token. Name the credential clearly, such as Airtable Pinterest.
- Open the Airtable nodes and select your Airtable credential. Pick your base and table or keep the provided base and table. Confirm the upsert operation and set the unique field to pin_id.
- Open the HTTP Request node for Pinterest. Add the Authorization header with the value Bearer YOUR_PINTEREST_TOKEN. Create or fetch this token from the Pinterest developer portal. Run the node once to confirm you get pin data.
- Connect OpenAI: in the n8n credentials manager create a new OpenAI API Key credential. Get the key from your OpenAI account. Select this credential in both OpenAI model nodes.
- Connect Gmail: open the Gmail node, click Create new credential, and follow the on screen steps to allow send email. Send a test email to confirm access.
- Open the AI Agent node and choose the Airtable Tool with your Airtable credential so the agent can read the table. Keep the prompt text that asks for trends and new pin ideas.
- Review the Code node output by running it once. Check that each item includes the Organic tag and the fields you need. If fields are missing, adjust the mapping.
- Set the schedule to your preferred day and time in the Schedule Trigger node. Save the workflow and enable it.
- Run a full test: execute from the trigger, verify pins appear in Airtable, review the AI summary output, and confirm the email arrives in your inbox.
- Troubleshoot common issues: a 401 error from Pinterest means the token or scope is wrong, duplicates in Airtable mean the unique field is not set to pin_id, and missing emails often relate to Gmail permission or spam filters.
Need help or want to customize this?
Ask in the Free Futurise Community.
Similar Templates
These templates were sourced from publicly available materials across the web, including n8n’s official website, YouTube and public GitHub repositories. We have consolidated and categorized them for easy search and filtering, and supplemented them with links to integrations, step-by-step setup instructions, and personalized support in the Futurise community. Content in this library is provided for education, evaluation and internal use. Users are responsible for checking and complying with the license terms with the author of the templates before commercial use or redistribution.Where an original author was identified, attribution has been provided. Some templates did not include author information. If you know who created this template, please let us know so we can add the appropriate credit and reference link. If you are the author and would like this template removed from the library, email us at info@futurise.com and we will remove it promptly.
