Transfer of data regarding the number of ads in the Facebook Ads Library

[v.hrytsiuk]

Our team currently requires a tool that can update data weekly, specifically the number of ads, the number of followers, and likes in a Google Sheet in designated cells. Can your tool assist with this?

[Jess]

Yes, Bardeen should be able to accomplish this task for your team.

Essentially, automations can be executed to run on a scheduled basis(weekly, every two minutes, once a year, etc). Then, you’d be able to create a customized scraper to obtain any data from the Facebook Ads library website page or pages and then update your Google Sheet with the scraped data.

I hope this helps!

[v.hrytsiuk]

Thank you for the information. Is it possible to select an existing row or column in the sheet to export data, particularly numbers, using your tool? If so, could you please provide instructions on how to do this?

[Jess]

uhm not exactly sure if I’m following the use case here. but it is possible to run through specific rows and columns using Bardeen.

If you could further explain the end result you are looking for, I’ll be able to better provide a more clear answer.

Thank you,
Jess

[v.hrytsiuk]

I want to check this number of ads every week and add the result in the rows in the sheet here.

[Jess]

Oh yes, Bardeen can easily do this. In general, the automation would work as follows:

1. Schedule to run Weekly
2. Scrape the “250” value
3. Add Row to GSheet (Select GSheet, Select which Tab, Map to correct column)

I hope this helps!

[v.hrytsiuk]

Sorry, what I did wrong. I can’t set up to add number not text??

[Jess]

Could you please share your Google sheet with edit rights and the automation?

[v.hrytsiuk]

Yes, of course. But I need your email to add you

[v.hrytsiuk]

Google Sheets: Sign-in

[v.hrytsiuk]

Now I have a problem, how to choose the right column and row.

[Jess]

You don’t need my email, just share the link with “Anyone”

[v.hrytsiuk]

https://docs.google.com/spreadsheets/d/17VqSXQRLKXmbR3oYtGhXPpNgsncwQh2yY-hlDB1763s/edit?usp=sharing this sheet

[Jess]

Great I’ve requested access

Still need the link to the shared automation.

[v.hrytsiuk]

https://docs.google.com/spreadsheets/d/17VqSXQRLKXmbR3oYtGhXPpNgsncwQh2yY-hlDB1763s/edit?usp=sharing I got access

[Jess]

now we just need the shared playbook… Thank you!

[v.hrytsiuk]

{{playbook_title}}

[Jess]

Here’s the updated playbook that works: Shared Playbook Template (bardeen.ai)

I updated the Scraper template to use regular expression to only include the number.

Thank you,
Jess

[v.hrytsiuk]

Thank you, can you double-check this template because I had the same results as usual(((( And can you explain how to select another row and column?

[Jess]

Try this one: Shared Playbook Template

@v.hrytsiuk

And can you explain how to select another row and column?

I’m not sure what you’re asking. Could you please explain further?