From GoogleSheet I would like to search text if it exists in docs, pdf files with matching file names (or fileID). Is there a way to do that? I am somewhat familiar with Scripting in googlesheet Parameters are very similar to the way in which you can search form drive.google.com Search Bar.

  • this is too broad pls describe your issue in more detail – user0 May 3 '19 at 11:53
  • I have 2 cells in google sheet Cell A1 containing Search String, Cell B1 Containing Google Docs ID, when I enter word in search string - Cell C1 should have number of occurrences the of cell A1 in googledoc B1. Eg - if I enter "video" in cell A1 and B1 googledoc contains 10 times word "video", Cell C1 should have value 10. – Anjan Mehta May 3 '19 at 17:06
  • can you share a copy of your sheet? – user0 May 3 '19 at 18:58

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.