Is it still possible to get tweets from twitter from a person of interest and save them in a google sheet? I am confused about the use of the TwitterAPI on Make, hearing that this is not possible. Thank you!
Welcome to the Make community!
You can find third-party Twitter APIs on RapidAPI. It’s easier than maintaining and paying for your own Twitter subscription.
How to call an API on RapidAPI
Use the HTTP “Make an API Key Auth Request” module.
Create a new keychain connection and insert your RapidAPI API Key.
Key: <YOUR_RAPIDAPI_KEY>
API Key parameter name: X-RapidAPI-Key
You can reuse this RapidAPI keychain for all API calls to RapidAPI – you’ll just need to change the X-RapidAPI-Host value based on the API you are calling.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
1 Like
Thank you very much @samliew,
calling an API endpoint with the http request module works perfectly fine. 
Now I have issues with parsing (?) the JSON I get from twitter. I want to save the tweets in a google sheets for this reason I connected the https request module with an Iterator, thinking that I get an array of tweets which I need to iterate over. The screenshot shows the JSON in full length until the specific key which is “full_text”. When running the iterator module I am called to add an item after the “instructions” key. Here I am lost.
If you’ll find time it would be great if you could help me again. Best
No problem, really 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!
Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —
Getting Started
- Help Centre | Tutorials – Make “Manual”
- Make Academy – Basics 101: Learn Make and get certified
Help Centre Basics
- Mapping – What is mapping? What can I map?
- Mapping with arrays – How to map items in an array
- Aggregate an array for mapping complex fields
- Date Format: tokens for
parseDate| tokens forformatDate - HTTP modules – Make a request, Get (download) a file
- Webhooks – Error Handling, Responding to webhooks
Articles & Videos
- Router Magic Formula - YouTube
- Error Handlers in Make - YouTube playlist
- Getting started with OpenAI - How to setup and use OpenAI (ChatGPT) in Make
- How to use Regex in Make - How to use pattern matching to extract the text you want
- Webhooks – Make Academy – tutorial on how to use Webhooks
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.