Information not being delivered to google sheets

The scenario is built to scrape google maps for websites and emails, everything runs fine except for the delivery of the information into google sheet. Thanks in advance.



Hi @Ethan1 and welcome to the Make Community!

Can you explain what’s happening and what you were expecting?

L

Welcome to the Make community!

It appears that there is no output (matches) from the Text Parser module, hence the “Add a Row” module did not run.

If you need further assistance, please provide the following:

1. Scenario Blueprint

Please export the scenario blueprint file to allow others to view the mapped variables in the module fields. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

2. Output Bundles of Modules

Please provide the output bundles of the modules by running the scenario (or get from the scenario History tab), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.

A. Upload as Text File

Save each bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.

B. Insert as Formatted Code Block

If you are unable to upload files on this forum, alternatively you can paste the formatted bundles.
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

Providing the input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

Following these steps will allow others to assist you here. Thanks!

3.

Could you go to regex101.com, paste in your Pattern at the top and paste a complete/full example text you are trying to match from below it?

Then, save the regex example and share the link with us here.

This will allow others to assist you here with your pattern. Thanks!

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.

1 Like

Hi, so I am scraping google maps for the business URL and Email. The second html module is pulling the URL well as you can see in this attached file. The last text parser is coded to pull the emails from the HTML. Everything runs and returns the information but won’t transport over to the google sheet and I don’t know why.

I just ran it with “Continue the execution of the route even if the module finds no matches” and it went through but only put the url but didn’t input the email. So I assume it’s not pulling the email correctly. If I open up the parser after it’s run it shows this.


It is identifying the code when scraping the url but not pulling the actual email.

Sincerely apologise, I had a space at the end of my code.

2 Likes