# Insert links in 200 texts from a 250 keywords and url on a google sheet **URL:** \ **Category:** Questions\ **Tags:** arrays, filters\ **Created:** [September 1, 2024, 8:15am UTC](https://community.make.com/t/insert-links-in-200-texts-from-a-250-keywords-and-url-on-a-google-sheet/53651 "2024-09-01T08:15:37Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Bertrand\_Levet](https://avatars.discourse-cdn.com/v4/letter/b/eb8c5e/32.png) [@Bertrand\_Levet](https://community.make.com/u/Bertrand_Levet)\ **Post date:** [September 1, 2024, 8:15am UTC](https://community.make.com/t/insert-links-in-200-texts-from-a-250-keywords-and-url-on-a-google-sheet/53651/1 "2024-09-01T08:15:37Z")
Hello, i want to insert links in a text. For that I have a google sheet with 2 columns, one for keywords and one for urls with about 250 rows. How can I search keywords in my text and insert the link with a minimum of operations? I have 500 texts to filter… ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [September 1, 2024, 9:06am UTC](https://community.make.com/t/insert-links-in-200-texts-from-a-250-keywords-and-url-on-a-google-sheet/53651/3 "2024-09-01T09:06:26Z")
Welcome to the Make community! I would suggest completing the **Make Academy** before jumping into building a complete scenario. If you need **specific assistance** when you are **building a scenario** it’s easier to help you then. Otherwise, you can also **hire a professional** by posting a request in the #Hire a Pro category. Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too — ### Getting Started - [Help Centre](https://www.make.com/en/help) | [Tutorials](https://www.make.com/en/help/tutorials.html) – Make “Manual” - [Make Academy](https://academy.make.com) – Basics 101: Learn Make and get certified ### Help Centre Basics - [Mapping](https://www.make.com/en/help/mapping/mapping) – What is mapping? What can I map? - [Mapping with arrays](https://www.make.com/en/help/mapping/mapping-arrays) – How to map items in an array - [Aggregate an array for mapping complex fields](https://www.make.com/en/help/tools/flow-control#customizing-the-output) - **Date Format** : [tokens for `parseDate`](https://www.make.com/en/help/functions/tokens-for-date-time-parsing) | [tokens for `formatDate`](https://www.make.com/en/help/functions/tokens-for-date-time-formatting) - [HTTP modules](https://www.make.com/en/help/tools/http) – Make a request, Get (download) a file - [Webhooks](https://www.make.com/en/help/tools/webhooks) – Error Handling, Responding to webhooks ### Articles & Videos - [Router Magic Formula](https://www.youtube.com/watch?v=4Q-5BsCtJu4) - YouTube - [Error Handlers in Make](https://www.youtube.com/playlist?list=PLRE9E-rAD8U10mx2TRs54Nq1XJDdK9Kx4) - YouTube playlist - [Getting started with OpenAI](https://community.make.com/t/getting-started-with-openai-gpt-3-and-make/7796) - How to setup and use OpenAI (ChatGPT) in Make - [How to use Regex in Make](https://community.make.com/t/how-to-use-regex-in-make/202) - How to use pattern matching to extract the text you want - [Webhooks – Make Academy](https://academy.make.com/courses/IntermediateC04) – tutorial on how to use Webhooks Hope this helps! Let me know if there are any further questions or issues. — @samliew * * * P.S.: Did you know, [the concepts](https://community.make.com/t/make-academy-course-overview/29699) of about 70% of questions asked on this forum are already covered in the [Make Academy](https://academy.make.com). Investing some effort into it will save you lots of time and frustration using Make later! ---
**Author:** ![Bertrand\_Levet](https://avatars.discourse-cdn.com/v4/letter/b/eb8c5e/32.png) [@Bertrand\_Levet](https://community.make.com/u/Bertrand_Levet)\ **Post date:** [September 2, 2024, 9:28am UTC](https://community.make.com/t/insert-links-in-200-texts-from-a-250-keywords-and-url-on-a-google-sheet/53651/4 "2024-09-02T09:28:32Z")
I don’t have a scenario yet, i’m looking for a method. ---
**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\ **Post date:** [December 1, 2024, 10:42am UTC](https://community.make.com/t/insert-links-in-200-texts-from-a-250-keywords-and-url-on-a-google-sheet/53651/5 "2024-12-01T10:42:08Z")