I use Zapier to automatically send information from blog posts in feedly to a Google Sheet. I want to create document as automatically as possible. I have these columuns:

Author    Source    Title    Link    Category

I want to sort the rows by category, which isn't a problem, but then create a new cell with the title that is linked to the article. I would also love to have the author and source underneath each title so I can easily create a document and email it out to teachers. It should look like this:

Control of Newark Schools Is Back in City Hands After State Board of Ed Vote John Smith - Newark News

MoMath with "The Global Math Project" Exceeds Goal of Reaching More Than One Million Students in over 100 Countries Bill Blanks - Math Blog

And the titles would be clickable links to the posts.

Thanks for any help everyone, I'm a one man show and she as much automation as I can get.

  • Have you tried the HYPERLINK built-in function? – Rubén Jan 10 '18 at 17:46
  • I have only used it to highlight text in a cell and create a hyperlink. I need my text is in a cell adjacent to the link I want to use and I'd like to automate the process with a formula, plugin etc. Any ideas? – Bill T Jan 10 '18 at 20:51
  • Idea: use the built-in HYPERLINK function that you already know. If this not enough explain what do you mean by "automate". – Rubén Jan 10 '18 at 23:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.