hello everyone! I’d like to share my Facebook Insights to Google Sheets, but I can’t…
this is the connection I created, modules are working but nothing shows up on Google Sheets. Why do you think?
What’s the purpose of using the Aggregator in between?
From what I can see, if you need to record Facebook Insights daily, you can simply set the “Get Insights” module to use today’s date and directly map the results into your sheet.
If you’re looking for weekly or monthly data, you can schedule the scenario to run on a weekly or monthly basis. You can also add a breakdown by day, which will separate the bundles for each individual date.
I select the data which I want to follow and aggregator is responsible to collect and send it to the sheets. (I saw a comment for this on forum) but with or without aggregator, nothing is coming to sheets.
Troubleshoot:
- Check Data is empty from FB insights. (solution: get insights for larger time period)
- No mappings in Sheet. (solution: check the mappings are from FB module)
- Issue with sheet (solution: verify the sheet is selected correctly)
hello, sorry for the late respond. with your answer I’m now able to get my google sheets report but the problem is this “Facebook Insights” doesn’t count the messaging ads which we use it for our WhatsApp acc. that would be great if anyone knows how to track messaging ads
This is because the “Facebook Insights” module may be a polling trigger, and is returning empty bundles.
Another issue might be that the Array Aggregator has been configured to halt the scenario if there are no items that are aggregated.
Polling Triggers & Empty “Check Runs”
This is because the module is a POLLING trigger, and not an INSTANT (Webhook) trigger.
If you don’t see any bundles from the trigger module and operations on the rest of the modules, it means there are no new responses (empty output bundle) when the scenario ran to check for new items. This is called a “Check run”.
There are two main types of triggers, Polling (scheduled), and Instant (webhooks). Polling triggers can only run on a schedule. Instant triggers can be run as soon as data is received by the webhook.
- Polling means Make checks external service for changes (pull changes to Make).
- Webhook (instant) triggers means external service calls Make when there are new changes (push changes to Make).
The module you are using does not push changes — it’s basically a API request that Make has to occasionally “call” to fetch the latest changes/items.
To find out more on the different types of Trigger modules, see refer to Types of Modules and Webhooks sections of the Make Help Centre.
If you want your scenario to only run when there is new data (and not on a schedule or timed interval), see if your app has an “Instant” or “Webhook” trigger in Make. If not, check if the third-party service has a feature that can send out a webhook when content is created/updated - and then you can point it to a “Custom Webhook” trigger in your scenario.
If you want to re-run your scenario on older data,
Polling Triggers: Epoch Panel & Selecting Older Data
Go to the Epoch Panel, by right-clicking on the trigger module (polling triggers only), and select “Choose where to start” from the list of options in the context menu.
If you select “From now on”, the next time the scenario runs it will only return new data (or nothing if there is no new data).
You can also select other old data to re-run your scenario with next using the “Choose manually” option. This will then show you a list of previous historical items you can select to process the next time the scenario is triggered.
For more information, see
Hope this helps! Let me know if there are any further questions or issues.
— @samliew