Need help using Google I'm Feeling Lucky to return company url from company names in G Sheets. TYTY!

Stephen Mattison

unread,

Apr 7, 2016, 1:46:46 PM4/7/16

to Blockspring

Howdy! Thanks for the very COOL Sheets Add-on! Can't wait to figure out how to make it work for me!!

Firstly, I need to run a Google I'm Feeling Lucky query to find company website url from a column of business names in

Google Sheets. I watched the video that shows how to do this with Bing, but I have better luck with Google. How do I do this amazing procedure using Google? I went thru the procedure to get my own custom API as instructed. Now I have no idea how to find that info. I know there's a custom Google IFL API, don't know how to use it. Thanks in advance!!! Steve

Stephen Mattison

unread,

Apr 7, 2016, 5:13:34 PM4/7/16

to Blockspring

Also, the Sheet has about 30% of the URLs already filled in, so I also need a way to tell it to only run Block in empty cels. TYTYTY!!!!

Paul Karayan

unread,

Apr 7, 2016, 6:39:18 PM4/7/16

to Stephen Mattison, Blockspring

Hi Stephen,

The Bing! API is developer friendly which is why we've worked with it generally. What exactly are you trying to do here? There may be a better way I can share with you.

Also - when you talk about the sheet being 30% filled in, is this for a specific template? If you can share spreadsheets with me, it'll greatly improve my ability to help. p...@blockspring.com

Thanks, and glad you like the plugin!

best,

PK

--
You received this message because you are subscribed to the Google Groups "Blockspring" group.
To unsubscribe from this group and stop receiving emails from it, send an email to blockspring...@googlegroups.com.
To post to this group, send email to block...@googlegroups.com.
Visit this group at https://groups.google.com/group/blockspring.
To view this discussion on the web visit https://groups.google.com/d/msgid/blockspring/fdf6314b-630e-4e5c-a644-d687759076c1%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

Stephen Mattison

unread,

Apr 8, 2016, 11:07:06 AM4/8/16

to Blockspring, Stephen Mattison

RESOLVED! I found under the Advanced section on bottom how to Insert Block as a formula. Insert formula with x-Box, or whatever's there, then just swap in your Target Cel (mine was A2) and it works, SO SWEET! Then I could just drag that box down the column to enter the Bock in every row, it auto changed the Target Cel for each row. Took about 2 minutes to query and fetch beautiful URLs for column of 400 Company names. It worked so well, that I didn't even bother adding code to skip cels with URL already entered, I just let the Block enter new ones, mostly better ones. It did fetch a few yahoo.com, and Facebook.com, but looks like it got 95+% correct. Saved me half a day of hair pulling right there!! I also now automatically have a completely full column of MOZ ratings for each URL, TY again! Just this basic detailed info can really help Sales gauge how well a business is operating, and where they would see biggest ROI. PERFECT!! TYTYTY BLOCKSPRING!! +paulkara

Stephen Mattison

unread,

Apr 8, 2016, 11:08:18 AM4/8/16

to Blockspring

RESOLVED! I found under the Advanced section on bottom how to Insert Block as a formula. Insert formula with x-Box, or whatever's there, then just swap in your Target Cel (mine was A2) and it works, SO SWEET! Then I could just drag that box down the column to enter the Bock in every row, it auto changed the Target Cel for each row. Took about 2 minutes to query and fetch beautiful URLs for column of 400 Company names. It worked so well, that I didn't even bother adding code to skip cels with URL already entered, I just let the Block enter new ones, mostly better ones. It did fetch a few yahoo.com, and Facebook.com, but looks like it got 95+% correct. Saved me half a day of hair pulling right there!! I also now automatically have a completely full column of MOZ ratings for each URL, TY again! Just this basic detailed info can really help Sales gauge how well a business is operating, and where they would see biggest ROI. PERFECT!! TYTYTY BLOCKSPRING!! +paulkarayan

On Thursday, April 7, 2016 at 12:46:46 PM UTC-5, Stephen Mattison wrote:

Paul Karayan

unread,

Apr 8, 2016, 4:47:47 PM4/8/16

to Stephen Mattison, Blockspring

Hi Stephen,

Glad you got it working - I was poking around a bit in your sheet and really cool to see where you're able to pull Blockspring to help.

The big advantage I see for you to move to the basic Insert instead of the Advanced formula is that you'll have control over when the Block function runs. You may run over your Bing! API limit otherwise, so in the meantime just be careful not to refresh too often (or copy and paste the results as values).

Delighted to hear about MOZ, as well. Let us know if there's anything else we can help with!

best,

PK

--

You received this message because you are subscribed to the Google Groups "Blockspring" group.
To unsubscribe from this group and stop receiving emails from it, send an email to blockspring...@googlegroups.com.
To post to this group, send email to block...@googlegroups.com.
Visit this group at https://groups.google.com/group/blockspring.

To view this discussion on the web visit https://groups.google.com/d/msgid/blockspring/b91679bc-9f22-47e4-94a2-ee6d09d2dedd%40googlegroups.com.

Brian Kenyon

unread,

Sep 9, 2016, 11:02:47 AM9/9/16

to Blockspring

What was the exact formula that you entered into the cell?

Were you using Bing or Google Search?

Im currently hitting a limi on the bing searches. :(

Nikolaos Malamis

unread,

Oct 20, 2017, 6:07:25 AM10/20/17

to Blockspring

Hey, i do have a question..

Do i still need to sign up for Bing Api or i can do this using this form https://open.blockspring.com/apps/bing_search_jobs?app_id=1

I have a list of 5k company names and i want to find their domain urls at once!

Is there any limit?

Or i just have to purchase credits and do it!

Thank you!

On Friday, April 8, 2016 at 11:47:47 PM UTC+3, Paul Karayan wrote:

Hi Stephen,

Glad you got it working - I was poking around a bit in your sheet and really cool to see where you're able to pull Blockspring to help.
The big advantage I see for you to move to the basic Insert instead of the Advanced formula is that you'll have control over when the Block function runs. You may run over your Bing! API limit otherwise, so in the meantime just be careful not to refresh too often (or copy and paste the results as values).

Delighted to hear about MOZ, as well. Let us know if there's anything else we can help with!

best,
PK

On Fri, Apr 8, 2016 at 8:08 AM, Stephen Mattison <stephenm...@gmail.com> wrote:

RESOLVED! I found under the Advanced section on bottom how to Insert Block as a formula. Insert formula with x-Box, or whatever's there, then just swap in your Target Cel (mine was A2) and it works, SO SWEET! Then I could just drag that box down the column to enter the Bock in every row, it auto changed the Target Cel for each row. Took about 2 minutes to query and fetch beautiful URLs for column of 400 Company names. It worked so well, that I didn't even bother adding code to skip cels with URL already entered, I just let the Block enter new ones, mostly better ones. It did fetch a few yahoo.com, and Facebook.com, but looks like it got 95+% correct. Saved me half a day of hair pulling right there!! I also now automatically have a completely full column of MOZ ratings for each URL, TY again! Just this basic detailed info can really help Sales gauge how well a business is operating, and where they would see biggest ROI. PERFECT!! TYTYTY BLOCKSPRING!! +paulkarayan

On Thursday, April 7, 2016 at 12:46:46 PM UTC-5, Stephen Mattison wrote:
Howdy! Thanks for the very COOL Sheets Add-on! Can't wait to figure out how to make it work for me!!
Firstly, I need to run a Google I'm Feeling Lucky query to find company website url from a column of business names in
Google Sheets. I watched the video that shows how to do this with Bing, but I have better luck with Google. How do I do this amazing procedure using Google? I went thru the procedure to get my own custom API as instructed. Now I have no idea how to find that info. I know there's a custom Google IFL API, don't know how to use it. Thanks in advance!!! Steve

--
You received this message because you are subscribed to the Google Groups "Blockspring" group.

To unsubscribe from this group and stop receiving emails from it, send an email to blockspring+unsubscribe@googlegroups.com.

To post to this group, send email to block...@googlegroups.com.
Visit this group at https://groups.google.com/group/blockspring.

Reply all

Reply to author

Forward