Apify and Crawlee Official Forum

Updated 3 months ago

actor api/xml/google sheets related (looking for advice)

hi, im a noobie to apify and have limited coding knowledge
looking to have some custom actors made in general if i can figure out how to use this platform...

for now im trying to make a bunch of POST/GET requests (not sure) to USPS Verify api which gives xml output.

https://console.apify.com/actors/UkYNraodH8de76iZ7/console
or
https://console.apify.com/actors/5erSruYGRJ6qvuh2v/console

works on test input url's

(http://production.shippingapis.com/ShippingApi.dll?API=Verify&XML=%3CAddressValidateRequest%20USERID=%27117PRIVA1637%27%3E%3CRevision%3E1%3C/Revision%3E%3CAddress%20ID=%270%27%3E%3CAddress1%3E12233%20S%20MCDANIEL%20ST%3C/Address1%3E%3CAddress2%3E%3C/Address2%3E%3CCity%3E%3C/City%3E%3CState%3EIL%3C/State%3E%3CZip5%3E60803%3C/Zip5%3E%3CZip4%3E%3C/Zip4%3E%3C/Address%3E%3C/AddressValidateRequest%3E) for example....

i have a list of 17k address in a google sheet that i need to get the data from...

whats the best way to post the urls into one of the actors
and call the data ? they both output in json format, and i can call importjson custom function in google sheet that works quite well. but im confused with the multiple endpoints that i can use and ultimately want the data appended to the same row in google sheets...

https://console.apify.com/actors/uCbMx3aLeKZLuDKvH/console

looks like it could work for that part...

any advice is much appreciated
v
g
O
6 comments
happy to pay someone to help me understand / configure this
You can download your 17k links from your google sheet, feed those into one of the actors(in a txt file format) to scrape/fetch the parsed data. The parsed data would then be stored into a dataset from which you can then export the results to your google sheets.

You may need to transform the data based on your requirement before exporting to google sheet.
text specifically vs csv ?
I am assuming that you only have 1 column of data(with the links). If that is that case you can copy all the links in a txt file and import it in your actor's input(text file input).

You can ask for help in channel
Add a reply
Sign up and join the conversation on Discord