Transform "null" values into actual (placeholder)values

Hey! There are definitely ways around this depending on what you are trying to do, however I’m not quite sure of the format you would like to enter into Google sheets? 

(A screenshot from Google sheets would be super helpful if possible)

Hey! If you use “Create Spreadsheet rows”, this has line item support, and you can paste your data right in. 

However, I see that your data is a combination of the columns, and not split into rows. In that case, you will need to use a code step to format the data in the way you like - Building out your arrays for each column. 

If you’re familiar with code, this should be relatively quick, if not, I suggest hiring a Zapier expert who can help you here. You can find the Experts directory here: https://zapier.com/experts/

Yeah - This is by design - I’ve spent much time solving problems like this with webhook responses. The short answer is - what you are trying to do is not possible with Zapier’s webhooks currently because of how they handle the response. You will need to make an API call with a code step and handle the response yourself. 

const content = await rawResponse.json().then((data) => {
	function ColumnPair(columnName, columnValue) {
		(this.columnName = columnName), (this.columnValue = columnValue);
	}
	let combined = [];

	var columns = data.Result.Customfields;

	for (var i = 0; i < columns.length; i++) {
		if (columns[i].ColumnValue.length < 1) {
			columns[i].ColumnValue = 'n/a';
		} else {
			columns[i].ColumnValue;
		}
	}

What I am doing here is sending an API call, then handling the null values myself. You can see this in this part here:

		if (columns[i].ColumnValue.length < 1) {
			columns[i].ColumnValue = 'n/a';