About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • How to update Notion database of Twitter followers ranking automatically every day
Question

How to update Notion database of Twitter followers ranking automatically every day

  • 24 March 2023
  • 4 replies
  • 83 views
Toru

I want to create a ranking of the number of Twitter followers in Notion database and have it automatically updated every day.


Let's say I have a list of Twitter user IDs of CEOs of tech companies in Notion. Is it possible to get the ID from the first row of the database, get the current number of Twitter followers, update the column and repeat that from the top to the bottom of the database?

 

If it’ impossible to do that with Notion, how about Google sheets or something?

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Brem
Userlevel 4
Badge +6

Hi @Toru 

I’m not sure what you want to achieve for this Zap but to help you further on this and be able to suggest workarounds, do you have a specific use case that I could help out with? If you can phrase it in the “When A happens in Service X, B should happen in Service Y” format, that’ll help me make sure I give you the best suggestion possible, so thank you in advance!

I want to make sure we're on the same page so I can point you in the right direction!

Troy Tessalone
Userlevel 7
Badge +14

Hi @Toru 

Good question.

Here’s a possible solution…

Use Airtable as your database.

Airtable has Views.

Views can be sorted.

Views can have filters. (e.g. Field X = Y)

Views can be used to trigger Zaps.

You can configure logic to make records, move in/out of the view each day.

Zap steps

  1. Trigger: Airtable - New/Updated Record
  2. Action: Twitter - Search Users
  3. Action: Airtable - Update Record
    1. Map the Record ID from Step 1

 

 

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Toru

Thank you, Brem and Troy.

Below is what I want to achieve. 

 

Triger: Schedule by Zapier (Everyday)

Action - step 1: Get the @ID from the first row of database (‘elonmusk’ for this case)

Action - step 2: Get the number of Twitter followers of the accounts. 

Action - step 3: Update the number of Followers in database.

Aciton - step 4: repeat step 1 to 3 for sundarpichai/satyanadella.

 

 

ken.a
Userlevel 7
Badge +6

Hey @Toru,

Thanks for the clarification! I think Troy’s suggestion is the best approach here. Have you tried it out?

Please keep us posted if it’s working or not.

Thanks! 😊

Terms & Conditions