# Simple: Trying to pull a line of text from, say, a spreadsheet, using it to replace the placeholder in another document (or spreadsheet). Just starting my make journey - go easy :) **URL:** \ **Category:** Beginner Questions\ **Tags:** functions, mapping\ **Created:** [May 27, 2024, 8:29am UTC](https://community.make.com/t/simple-trying-to-pull-a-line-of-text-from-say-a-spreadsheet-using-it-to-replace-the-placeholder-in-another-document-or-spreadsheet-just-starting-my-make-journey-go-easy/38990 "2024-05-27T08:29:17Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Jayson\_Freshton](https://avatars.discourse-cdn.com/v4/letter/j/e19adc/32.png) [@Jayson\_Freshton](https://community.make.com/u/Jayson_Freshton)\ **Post date:** [May 27, 2024, 8:29am UTC](https://community.make.com/t/simple-trying-to-pull-a-line-of-text-from-say-a-spreadsheet-using-it-to-replace-the-placeholder-in-another-document-or-spreadsheet-just-starting-my-make-journey-go-easy/38990/1 "2024-05-27T08:29:18Z")
Hi there, Just starting my make journey and have been working through the academy. I’m just testing things at the moment, but I’ve hit a brick wall with the first thing I want to try. My goal is to pass the text from, say, a spreadsheet and insert it (or overwrite) in a position when some other text. The idea is to create a basic prompt to send to OPenAI. For example, I want the text found in a cell in the google sheet - let’s say a weburl - [www.amazon.co.uk](http://www.amazon.co.uk) I would then want that pulling into a google doc(?) to overwrite a place holder. So, my text in the google doc would be “_I want you to go to this website **(PLACE HOLDER HERE)** and give me a 100 word overview of the company_”. I would like the phrase (PLACE HOLDER HERE) to be replaced with the the webaddress pulled from the spreadsheet. But I just can’t seem to get this to happen using the Google doc ‘replace text’ action. Nothing happens! ![Screenshot 2024-05-27 at 09.22.51](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/9/7/97fd4fe7806116b2bc48e6db654e26fefe32da85.jpeg) ![Screenshot 2024-05-27 at 09.23.13](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/5/356d2d3d3a1969d27fe4174d5a3ba4ea5763d5df.png) Hopefully you understand what I’m looking to do(?). I suspect I’m not going the best way about it - my ultimate goal is basically to be able to pull bits from a spreadsheet, insert them into another piece of text whereever I specificy and then pass the prompt to an AI. Perhaps I"m making life complicated for myself? Any help you can provide would be gratefully received. John ---
**Author:** ![Msquare\_Automation](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/msquare_automation/32/6634_2.png) [@Msquare\_Automation](https://community.make.com/u/Msquare_Automation)\ **Post date:** [May 27, 2024, 9:50am UTC](https://community.make.com/t/simple-trying-to-pull-a-line-of-text-from-say-a-spreadsheet-using-it-to-replace-the-placeholder-in-another-document-or-spreadsheet-just-starting-my-make-journey-go-easy/38990/2 "2024-05-27T09:50:48Z")
Hi @Jayson_Freshton It is unfortunate that this didn’t work. Could you please share a screenshot of the Google Docs output? This will help us assist you better. If you require additional assistance, please don’t hesitate to reach out to us. [MSquare Support](https://calendly.com/msquarepro/meeting)| [Book Live Implementation](https://calendly.com/msquarepro/msquareautomation-live) Visit us [here](https://www.msquare.pro/) [Youtube Channel](https://www.youtube.com/channel/UCqidlIIwbejxZmRUWBICcjQ) ---
**Author:** ![Jayson\_Freshton](https://avatars.discourse-cdn.com/v4/letter/j/e19adc/32.png) [@Jayson\_Freshton](https://community.make.com/u/Jayson_Freshton)\ **Post date:** [May 27, 2024, 10:36am UTC](https://community.make.com/t/simple-trying-to-pull-a-line-of-text-from-say-a-spreadsheet-using-it-to-replace-the-placeholder-in-another-document-or-spreadsheet-just-starting-my-make-journey-go-easy/38990/5 "2024-05-27T10:36:50Z")
Yeah, I thought that - but - that ‘option’ isn’t available when selecting the ‘replace a text in a document’ action: ![GD4](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/4/8/48fdbc598cf26a23e9539e6c7a051c8098e45885.jpeg) You can see there’s no way to target a ‘variable’ in the google doc. Weirdly there does seem to be this option in the ‘create new document’ option: ![GDissue](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/1/e/1ee12b6e33baf2c3481acb7d403c4df250bd91a4.jpeg) …but as you can see I can’t seem to get that to work! I did seem to solve my previous problem as I changed the ‘connection’ to the google sheet from ‘Make Academy’ to ‘My Google connection’. (Not sure why there are both there). I’m not sure why that caused an issue though as it could clearly see my document. Ultimately though, I have managed to overwrite the google doc with the text in the google cell. I guess given this complexity I can’t help feeling I’m going about this the wrong way(?). At the moment, whilst this worked, it only really works for a ‘one shot’ deal. If I add a new row into the spreadsheet it won’t replace the text in the google doc anymore because the text it’s looking to replace is no longer there! What I really want to do it have it run through each row in the cell, create a new prompt for each - so any high level tips would be great… ---
**Author:** ![VinayakUpadhyay](https://avatars.discourse-cdn.com/v4/letter/v/dc4da7/32.png) [@VinayakUpadhyay](https://community.make.com/u/VinayakUpadhyay)\ **Post date:** [May 27, 2024, 10:55am UTC](https://community.make.com/t/simple-trying-to-pull-a-line-of-text-from-say-a-spreadsheet-using-it-to-replace-the-placeholder-in-another-document-or-spreadsheet-just-starting-my-make-journey-go-easy/38990/6 "2024-05-27T10:55:05Z")
You can do that directly without using Google doc module ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/b/5b52dde0d9e1b514e791090b725086033ffc17be.png) Search rows for getting values of A row ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/0/c/0c8ccca552b32ec1ec2d8458f86f441bae96aabc.png) ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/1/a/1a56ee5fa2ccf4dff558d21d7e46fbd537008ecd.png) ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/f/b/fb234d73f0930807c6e4c1b4b0bf87f794ea2dc2.png) Additionally, you can add a row for that corresponding row to save the input prompt in similar Google sheet ---
**Author:** ![Jayson\_Freshton](https://avatars.discourse-cdn.com/v4/letter/j/e19adc/32.png) [@Jayson\_Freshton](https://community.make.com/u/Jayson_Freshton)\ **Post date:** [May 27, 2024, 12:33pm UTC](https://community.make.com/t/simple-trying-to-pull-a-line-of-text-from-say-a-spreadsheet-using-it-to-replace-the-placeholder-in-another-document-or-spreadsheet-just-starting-my-make-journey-go-easy/38990/7 "2024-05-27T12:33:43Z")
Really appreciate your help. ---
**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:** [August 25, 2024, 12:34pm UTC](https://community.make.com/t/simple-trying-to-pull-a-line-of-text-from-say-a-spreadsheet-using-it-to-replace-the-placeholder-in-another-document-or-spreadsheet-just-starting-my-make-journey-go-easy/38990/8 "2024-08-25T12:34:04Z")