Create dynamic, draggable URL formulas by mapping URL parts to spreadsheet cells.
Paste the full URL, including the example values you want to replace. (e.g., `...&name=john%20smith&...`)
In the box below, use your mouse to click and drag to select a piece of text (e.g., "john"). Then, type the cell it corresponds to (e.g., "A2") and click "Add Mapping".
Paste this formula into your Google Sheet (e.g., in cell E2). You can then drag it down to apply to all rows.