What is your goal?
Send timesheet data from Square to Googlesheets
What is the problem & what have you tried?
Hi, I’m trying to pull timecard data from the Square Labor API and push each shift as a row into Google Sheets. My scenario is:
HTTP (Make a Request) → Iterator → Router → Google Sheets
The HTTP module is working correctly — Status 200, returning 30+ shifts in a nested array. When I expand the output I can see:
Data > shifts > [1, 2, 3… 30+]
Each shift contains fields like team_member_id, start_at, end_at, and a nested wage object with title and hourly_rate.
The problem: the Iterator is mapped to 1.data.shifts (selected from the variable picker, showing as a blue dynamic tag) but zero bundles are passing through. The scenario runs and completes with no operations after the HTTP module.
What I’ve tried:
Deleting and re-adding the Iterator
Mapping the array by typing manually vs selecting from variable picker
Adding a Parse JSON module between HTTP and Iterator
Running the scenario first to load data structure before mapping
Nothing has worked. The HTTP module consistently returns data but nothing flows through to the next module.
Any help appreciated.
Error messages or input/output bundles
4:36 PMPreparing scenario for running.
4:36 PMRequesting execution.
4:36 PMThe request was accepted. Waiting for the server.
4:36 PMThe scenario was initialized.
4:36 PMThe scenario was finalized.
4:36 PMThe scenario run was completed.
Welcome to the Make community!
We’d love to help, however, we require more information that demonstrates the problem to help us reproduce the scenario and any issues and errors. To allow others to assist you, please provide the following:
A. All Relevant Screenshots
We need to see what you’re working with to give you the best advice. Screenshots are important because Make is a visual editor — a picture provides us with more context.
It would help us identify the issue by having screenshots of:
- the full scenario, and the zoomed in parts of the scenario that you are referring to (if your scenario is huge),
- a full scenario run/execution from the history (showing output “speech” bubbles),
- relevant module fields (showing how you’ve used any built-in functions, and how you’ve mapped the variables),
- relevant filters between modules (showing which operators and any built-in functions you’ve used, and how you’ve mapped the variables),
- relevant module input/output bubbles,
- if applicable, any error messages,
- and if applicable, any external services (spreadsheet headers/ sample data/ regex101.com/ etc. to show the item/ record exists, and is set up correctly).
Expand Instructions ◀
Please directly upload screenshots into the post editor. Using the forum’s image hosting allows for zooming in when clicked, and avoids third-party cookies or tracking.
Taking Screenshots
- Microsoft Windows: Take screenshots using the “Windows Snipping Tool”, by pressing either PrtSc or WinShiftS keys on your keyboard.
- MacOS: Take screenshots by pressing CommandShift4 keys on your keyboard.
Uploading Images
- Drag image files directly into the rich-text editor, or
- Click on the upload button in the editor toolbar to select files:
B. Scenario Blueprint
Providing your scenario will allow others to quickly recreate and see how you have set up the mappings in each module, and also allows us take screenshots or provide module exports of any solutions we have for you in return. This would benefit you in implementing our suggestions as you can view screenshots of the changes or paste corrected modules back into your scenario.
Expand Instructions ◀
A. Export Blueprint
In the scenario editor, click the three dots at the top-right, then select “Export blueprint”.
B. Create Public Share Link
In the scenario editor, click on the Share button:
Read more about the scenario sharing feature in the Help Centre.
C. Properly-formatted Output Bundles from a Scenario Run
Please provide the Input / Output bundles of each of the relevant modules from the Scenario History, or by re-running the scenario.
Expand Instructions ◀
Click on the white speech bubbles on the top-right of each module and select “Download output (or input) bundles”.
A. Upload a Text File
Save each bundle contents in a plain text editor as a moduleNumber-output.txt file. Open the file to check if it has not added additional formatting or encoded the plain text.
-
You can upload files and images to this forum by clicking on the upload button:
Uploading an attachment here will look like this:
module1-input.txt (1.2 KB), module1-output.txt (3.4 KB)
B. Insert a Formatted Code Block
If you are unable to upload files on this forum, alternatively you can paste the bundles AND format them correctly with the “Preformatted Text” (code) button in the rich-text editor. Otherwise the forum software will change the content, making them invalid!
Formatting IS Important!
Here are some ways to provide text content in a way that it won’t be modified by the forum.
-
Method 1: Type code fence manually —
Manually type three backticks ``` in a separate line before and after the content, like this,
```
text goes here
```
-
Method 2: Highlight the pasted content, then click the preformatted text/code button —
-
Method 3: Upload your file elsewhere and share the public link —
This method is only advised for large files exceeding the forum upload limit.
Providing the Input / Output bundles will allow others to replicate what is going on, especially if there are complex data structures (like nested arrays and collections) and data from external services. This helps us with answering your question with valid examples, like mapping raw variable names (instead of the label/display name).
Sharing these details will make it easier for others to assist you, so that you can get better answers, faster.
— @samliew
P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!