Google Docs splitting to Google Sheets rows or columns

How To
,
1

Hi!
I need help to solve the problem to split a text (3 Newsletters in one Google Doc) and move each single Newsletter (text only) to single rows or columns, i.e. in different cells into a Google Sheet. The text splitter isn’t longer available. Can someone help and explain to me in a simple way how to do this a d which info I need to add in which fields per single automation. I am a newbie. Thanks a lot for any help.

2

Hey there,

how is the Google Doc formatted at the moment? Can you share what the output bundle looks like so we can see if there is a definitive and easily identifiable cutoff point between the newsletters? If there is, then a split() function should do the trick.

3

Hey,
here is one example attached - as pdf, usually it is an Google Docs file. The three " — " are the devider per single newsletter.

Thanks for your help.
27.03.2025 22_55_51 Newsletter.pdf (70.4 KB)

1 Like
4

Welcome to the Make community!

First, use the Google Docs “Get Content of a Document” module —

Gets a content of a document.

Then you can use a Text Parser “Match Pattern” module.

When reaching out for assistance with extracting text, it would be super helpful if you could share the actual text you’re trying to match. Screenshots of text can be a bit tricky, so if you could copy and paste the text directly here, that would be awesome! It ensures we can run it against test patterns effectively. If there’s any sensitive info, feel free to change it to something fictional yet still valid by keeping the format intact.

Providing clear text examples saves time on both ends and helps us give you the best possible solution. Without proper examples, we might end up playing a guessing game, and nobody wants that as it is a waste of time! You are more likely to get a correct answer faster. So, help us help you by sharing those text snippets.

Please format the example text this way to preserve line breaks and special characters:

These are the two ways to format text so that it won’t be modified by the forum:

  • Method 1: Type code block manually

    Add three backticks ``` before and after the content/bundle, like this:

    ```
    content goes here
    ```

  • Method 2. Highlight and click the format button in the editor

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

3 Likes
5

Thanks so much!!
I will now put this into place!

2 Likes