What are you trying to achieve?
I need to check on a spreadsheet cell for some keyword (one per line) and make an API request to check them on rapidapi.
The api request is already working, but I still need help on how to read one line at time to make the request for one keyword at time. But if its possible to check all keywords at the same it is also ok.
After that I need to list those keywords on the spreadsheet with it’s dificulty and volume search.
Another problem that I faced is to check the keywords by country.
This is my config for the rapidapi:
This is the request with the country:
curl --request GET \
--url 'https://semrush-magic-tool.p.rapidapi.com/keyword-Overview-Data?keyword=email%20marketing&country=us' \
--header 'x-rapidapi-host: semrush-magic-tool.p.rapidapi.com' \
I’m trying to send it as the above picture, but I don’t know if that is the correct way to do it.
On the item2 I have added the country from a spreadsheet.
Steps taken so far
I already have the keywords on the spread sheet, I have the api request working and writing on the spread sheet, but it only reads a single keyword.
There are the keywords on the spreadsheet:
This is how the result should be:
This is the scenario that I have at the momment:
So, my questions are:
1- How to I make the api requests for all those keywords? Do I need to do it one at time? Or can I do everything at the same time? And how to do for all of them?
2- How do I store the results before sending it to the spreadsheet?
3- How to configure the country on the api request?
Thank you very much!!
Kind regards!
Rodrigo
