No luck exporting google map scrap to google sheets

[Caleb_Munson]

I am trying to scrape Google Maps for leads and export them to Google Sheets. Here is the basic set up.

I think I have the data from Get Dataset Items correct. see here.

I’ve mapped my fields to columns in my google sheet.

When I run the last module (bulk add rows), nothing happens.

I get this pop-up,

I know that if I type data into these fields, it gets exported. but I do not know why the data from Get Dataset Items isn’t flowing through?

What have I done wrong?!?!?!

Thank you!

[samliew]

Welcome to the Make community!

You cannot individually run a single module if you don’t have example values of the “Data”, which you must input into the prompt when you manually run a single module.

Try running the full scenario instead by clicking the “Run Once” button:

For more information, see these duplicate questions previously asked and answered by other community members:

• Missing Values While Processing Google Forms Data - #2 by Henk-Operative
• Not able to use webhook data
• Make not recognizing value of a variable

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

— @samliew

[Caleb_Munson]

I cannot believe I missed that. and I’m embarrassed to say why…I was thinking that there was some memory stored from the previous running for each individual actor to use.

TY!!

[samliew]

No problem, glad I could help! May I suggest you complete the Make Academy so that you learn how to use Make to its full potential and avoid basic pitfalls like these?

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 | Tutorials – Make “Manual” - search for help here first
• Make Academy – Basics 101: Learn Make properly to get your money’s worth

Help Centre Basics

• Mapping – What is mapping? What can I map?
• Mapping with arrays – How to map items in an array
• Aggregate an array for mapping complex fields
• Date Format: tokens for parseDate | tokens for formatDate
• HTTP modules – Make a request, Get (download) a file
• Webhooks – Error Handling, Responding to webhooks

Articles & Videos

• Router Magic Formula - YouTube
• Error Handlers in Make - YouTube playlist
• Getting started with OpenAI - How to setup and use OpenAI (ChatGPT) in Make
• Text Parser module - Use pattern matching to extract the text you want
• Webhooks – Make Academy – tutorial on how to use Webhooks

1. If anyone has a new question in the future, please start a new thread. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely.

2. The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.

This marks the topic as solved, so that:

• others can save time when catching up with the latest activity here, and
• allows others to quickly jump to the solution if they come across the same problem

To do this, simply click the checkbox at the bottom of the post that answers your question:

3. Don’t forget to like and bookmark this topic so you can get back to it easily in future!

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

— @samliew