Hello,
I’m working on a system in Google Sheets that gathers the latest news posts via RSS feeds. Using Make, my goal is to automate the creation of social media posts based on these entries. I’ve linked the Google Sheet to Make using the Google Sheet Webhook, and while the scenario does work, I’m encountering an issue where the same post is being posted multiple times. I only want each post to be shared once. What adjustments do I need to make to resolve this problem?
Thank you in advance for your help!
How is your Watch Changes settings set up in Google Sheets itself?
Is is watching for any changes, or just changes to the approval column?
You might also need to provide your scenario for further investigation.
Please export the scenario blueprint file to allow others to view the mappings and settings. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.
(Note: Exporting your scenario will not include private information or keys to your connections)
Uploading it here will look like this:
blueprint.json (12.3 KB)
samliew – request private consultation
Join the Make Fans Discord server to chat with other makers!
1 Like
My Watch Changes node is set up like this. I believe it is checking the entire sheet. Is that correct?
Here is the Scenario:
blueprint.json (7.5 KB)
No, you should not watch the entire sheet. Go to the addon settings in the Google Sheets itself.
You should be able to restrict the changes to just the column, otherwise changes elsewhere will also trigger the scenario, which is what you are currently experiencing.
samliew – request private consultation
Join the Make Fans Discord server to chat with other makers!
1 Like
I’m just confirming with you: is this what you mean? Do I need to set the value for the range to the Approval Status column?
Everything is working perfectly now, I appreciate your help!
No problem, glad I could help!
1. If anyone has a new question in the future, please start a new thread. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely.
2. The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.
This marks the topic as solved, so that:
- others can save time when catching up with the latest activity here, and
- allows others to quickly jump to the solution if they come across the same problem
To do this, simply click the checkbox at the bottom of the post that answers your question:
3. Don’t forget to like and bookmark this topic so you can get back to it easily in future!
4. Do join the unofficial Make Discord server for live chat and video assistance
samliew – request private consultation
Join the Make Fans Discord server to chat with other makers!
1 Like
